Password Protect the Unhide Sheet Function

[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

 

[Frank Kabel]

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

 

[Gord Dibben]

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