Diablo3x.dk | Diablo 3: Reaper of Souls - News & Community
D3X Øvrige => Tech. Support => Emne startet af: SKT efter Januar 29, 2015, 07:54:02 pm
-
Skal have hjælp til dette: http://www.mrexcel.com/archive/VBA/1646.html (http://www.mrexcel.com/archive/VBA/1646.html)
Desired Scenario:
1. User opens spreadsheet.
2. Spreadsheet has four tabs.
3. User selects to view fourth tab (P&L).
4. Before able to view, user is prompted for a password.
5. If user enters correct password (airline), then allowed to view worksheet, else error message "incorrect password".
6. This password check happens each time the file is opened, but if the password is entered correctly once, then the password is not checked during the rest of file session.
Thanks in Advance!
Kører Excel 2011.
Edit:
Selvhjælp! Er fikset nu.
Til dem som meget gerne vil kende løsningen, så fandt jeg den her: http://www.mrexcel.com/forum/excel-questions/84690-password-unable-view-worksheet.html (http://www.mrexcel.com/forum/excel-questions/84690-password-unable-view-worksheet.html)
-
Godt arbejde. ;)