Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password to hide and unhide sheets
The only way u can allow selective access to hide r unhide
a worksheet is to protect the workbook with a password. If u set a password to protect the workbook, unless u unprotect the workbook u cannot hide r unhide a worksheet. So while opening the workbook the code will be workbook.protect "password" when the user wants to hide/unhide a sheet workbook.unprotect "password" worksheet.activate worksheet.hidden=true/false workbook.protect "password" Veera -----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 . |
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) | |||
Hide Unhide | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |