Password Protect the Unhide Sheet Function

  • Thread starter Thread starter jkarl
  • Start date Start date
J

jkarl

Excel Protection Question.

I would like to be hide an individual Sheet in a Workbook and the
password protect the Unhide function so that only selected Users ca
re-open the individual Sheet.

There are multiple sheets in the workbook and only one Sheet contain
sensitive data.

Thanks for any responses.

-Ji
 
Hi
first hide the sheet and then protect the workbook ('Tools -
Protection') and assign a password for this.

Note: these kind of passwords can easily be cracked by a determined
user
 
Jim

How knowledgeable are your users?

You could hide the sheet then protect the workbook via
Tools>Protection>Protect Workbook with a password.

Sheet and Book passwords are easily cracked by anyone with enough savvy to
visit the Internet and get a password cracker program.

Gord Dibben Excel MVP
 
Back
Top