Hiding and protecting a sheet

  • Thread starter Thread starter Cardinal
  • Start date Start date
C

Cardinal

I know how to protect a spreadsheet but is there anyway to protect a
spreadsheet, hide it and not allow someone else to unhide the
spreadsheet? I am using Excel 2000. Thank you.
 
Hide with code using xlveryhidden. Then it can only be unhidden with code.
Hide the code. Not foolproof but will stop most end users.
 
Just to add to Don's response...

You can actually change the worksheet's visible property inside the VBE. So
you'd want to protect that from snoopers, too.

But if you really have stuff that shouldn't be seen by others, this kind of
technique isn't very good. Excel's protection is easily broken.

If you have stuff that others shouldn't see, don't put it into excel. If you
have to put the info into excel, then don't share the info with others (or
untrustworthy others).
 
Easiest way is to hide the sheet and (password) protect the Work*book* (not
Worksheet - though it doesn't hurt). All caveats pointed out by Don and Dave
apply: There is nothing to stop users from unhiding the sheet as long as
they are eager to do so.
JM
 
Back
Top