| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide sheet on open only if password to modify is given
I currently have a sheet hidden on file/open. I have set the file/save
option to a password to modify. Is there a way to unhide the sheet only if the password to modify is given, but hide it if the file is opened as read-only? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Unhide sheet on open only if password to modify is given
You could check:
if thisworkbook.ReadOnly then 'do one thing else 'do something else end if Alex wrote: I currently have a sheet hidden on file/open. I have set the file/save option to a password to modify. Is there a way to unhide the sheet only if the password to modify is given, but hide it if the file is opened as read-only? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| password protect unhide sheet command | Excel Discussion (Misc queries) | |||
| Password required in VBA to open the sheet | Excel Worksheet Functions | |||
| Need to password protect work sheet and unhide rows. | Excel Discussion (Misc queries) | |||
| PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them | Excel Programming | |||
| password prompt to unhide sheet | Excel Programming | |||
Hybrid Mode
