hide sheets

[ttowncorp]

is there a way to once you put a sheet under Hide have it only viewable to admin users. or put a password on that sheet so one other then yourself or selected few can view it?

 

[kweaver]

You can accomplish this using a VBA feature.

If you open the VBA screen, click on the sheet you want inaccessible, then from the Properties Window, select the visible option for xlSheetVeryHidden.
They, to be sure no one can go poking around in there, password access to the VBA screen: Tools/VBA Project Properties/Protection

HTH

 

[Joe4]

Note that Excel security is actually not that secure, and pretty easy to break.

You don't even have to know how to break it to get to hidden information. Even though a sheet may be hidden, if someone knows it name (which can easily be seen in VBA), then can reference it, i.e. if "Sheet2" is the hidden sheet, you can still pull values from that sheet via formula:

=Sheet2!A1

So, these tools are best used to prevent casual/accidental access to data. If you absolutely want that data protected, Excel is not a good tool to do that (and would fail most corporate security audits!).

 

[ttowncorp]

i c. so you can hide the coding a password protect that, but not a sheet and add a password to that?

 

[Joe4]

i c. so you can hide the coding a password protect that, but not a sheet and add a password to that?

I am not sure if this is in response to my post or kweaver's.
You can hide and password protect a sheet, but that doesn't keep the data from still being accessible via formulas, like I showed.

 

[ttowncorp]

so when unhiding it does it prompt a password to view it or is the password just for preventing them from editing the sheet.?

 

[kweaver]

If you password the VBA, there will be a prompt. Otherwise, you cannot view nor edit the VBA.

I've always wondered why Microsoft didn't fully protect very hidden sheets.

 

[ttowncorp]

thanks for the info. that is strange that they don't have that basic option. what about this. make a black screen that covers the sheet, then have a way to enable and disable it with a specific key stroke combinations like hold s d f g and h all at the same time to turn it on or off. is that possible?