Lock a hidden worksheet

H

Helmut

For security reasons I would like to put a password on
"Format"-"Sheet"-"Unhide"
Is this possible? So the hidden sheets can really be hidden from other users?
 
D

Dave Peterson

You could protect the workbook.

tools|Protection|protect workbook|make sure the Structure box is checked.

That said, this kind of workbook protection is easily broken.
 
E

edcosoft

Let them unhide the worksheet but they won';t see anything if you
format FONT to "white" and then lock that spreadshet with a password;
Or format PATTERN to the same color as the font; Or, physically hide
the used columns and lock the spreadsheet, Or Conditionally Format the
block of used cells to do the above formatting from a formula in
another cell; Or do all of the above. ed
 
D

Dave Peterson

Worksheet protection suffers from the same protection as workbook
protection--both are easily broken.
 
E

edcosoft

If you follow my suggestions after they have broken the password they
will find a blank sheet, partidularly if you use a remote space on it.
Also, if you are really concerned, add several other "hidden"
worksheets, with or without data and other hiding methods ,and then
when closing the file change the name of your "real" hidden
worksheet,.or change the nane of the cells that referrence to it.. ed
 
Top