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
.
|