Require password to view worksheet

[WeThotUWuzAToad]

Hello,


How do you protect a given worksheet so that a password is required even to view the worksheet?


For example, suppose you have a workbook with four worksheets and you want the viewing of any given worksheet to require entry of a corresponding password (or a master password) as shown in the screenshot located here:

https://imgur.com/ceEayAx

I've googled this question but the results tend to address protection relating to change privileges rather than viewing privileges.


Thanks

 

[WeThotUWuzAToad]

Oops. I just saw your latest post. Thanks for the info and the link.

 

[Logit]

.

By the way, can you also tell me how to designate a different graphic (object) to use for opening the Password box?

You can paste the image on your sheet, then right click the image and select VIEW CODE. That will take you to the MACRO LISTINGS. Select the macro
for running the password (chkMacroaccess) and the next time you click the image ....

Resources : http://www.ozgrid.com/Excel/assign-macros.htm & https://www.tutorialspoint.com/excel_macros/excel_assigning_macros_to_objects.htm