Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password to hide and unhide sheets
There have been quite a few questions this week on this
topic - try search on the NG Basically, hide all the relevent sheets. Add a userform - with a text box for the password with the PasswordChar set to say asterisks. add another textbox for the username. add an OK button & code it to test the two entries - success should result in the worksheets being made visible, while failure might result in what? the workbook closing Patrick Molloy Microsoft Excel MVP -----Original Message----- I am looking for a way to hide a sheet for most of the users. But some of the users should be able to see the sheets. Therefore I am looking for a macro that unhides the sheet with a password the selected users knows. I am all out of ideas, and wondering if somebody knows a way. Thanks Nicolay . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbar buttons to hide/unhide sheets | Excel Discussion (Misc queries) | |||
Macro-Hide & Unhide Sheets with condition | Excel Discussion (Misc queries) | |||
Hide or unhide sheets based on cell | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
Password to hide and unhide sheets | Excel Programming |