I have a program that is password protected when opened, so it can either be
opened by a password and be edited or can be opened as read-only. When the
file is opened as a read-only is there a way to deny complete access to sheet
2, but when the correct password is entered then all sheets can be viewed.
This is becasue sheet 2 has information that is only needed by certain people.

Thanks People