How to hide a worksheet and set a password to protect someone else unhide it.

[Shu]

Hello,
I created some forms in a Excel file, which used the
information from worksheet in the file. I only want users
can access forms but not worksheets. So I need to hide all
worksheets in the file. However, people can unhide them if
they know how. How can I set a password so when someone
try to unhide them, they need to input a password?

Thanks a lot!

Regards
Shu

 

[Tom Ogilvy]

At least one sheet must be visible (it can be a blank sheet), but after you
hide the others:

Tools=>Protection=>Protect Workbook. Choose Structure as a minimum.

Assign a password.

 

[Guest]

Got it, Thanks very much, Tom

Shu

-----Original Message-----
At least one sheet must be visible (it can be a blank sheet), but after you
hide the others:

Tools=>Protection=>Protect Workbook. Choose Structure as a minimum.

Assign a password.

--
Regards,
Tom Ogilvy




.