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

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