Require Password to View Worksheet

M

Marc C

I have a workbook with 12 worksheets. One of them contains data that i
not for all to see. I'd like to require a password to view this on
worksheet while leaving the remaining sheets open to all. Right now I'
just hiding it, but I'd like to make it more secure. Any ideas? Thanks
 
D

Dave Peterson

If you protect the windows structure (tools|protect workbook), then that
worksheet can't be shown (until the workbook is unprotected).

The bad news is that there is code posted every day to do just that.

If you really want to protect the info on that worksheet--don't share it.
 
A

al

The problem with hide and protect is that you only have to copy and paste the worksheet to a new workbook and the entire contents are then available for all to see - I guess the only surefire way to protect the data is to put it in a linked book and password the book
 
Top