D3X Øvrige > Tech. Support

Excel hjælp

(1/1)

SKT:
Skal have hjælp til dette: http://www.mrexcel.com/archive/VBA/1646.html


--- Citér ---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!
--- Afslutning på citat ---


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

MonsterPool:
Godt arbejde. ;)

Navigering

[0] Emneindeks