Hide a sheet with a password

[manickmj]

I was wondering if I can hide a sheet that only opens with a password. I have all reviews in one file, but need to hide managers reviews from everyone... Thanks in advance, you guys are always very helpful!

[Controller 99]

Hi,

Tray this:

Please Login or Register  to view this content.

[seasider89]

An alternative option without using VBA would be to hide the sheet, then to select 'Protect Workbook' on the review tab and enter a password.

Then, it's impossible to unhide any sheets without knowing the password.

[Kamboj]

use this code

Please Login or Register  to view this content.

[popipipo]

Keep in mind that the protection in excel is very poor.
Passwords can be broken in seconds
If you use VBA then that need also a password

[manickmj]

Thank you seasider89 that worked perfectly!

[manickmj]

Thanks everyone for the help!