Hiding Sheets

[DG]

I know this is probably a dumb question, but is there a way to hide a sheet?
I want to put information in the sheet that my macros will use but don't
want the user to see or access.

DG

 

[Bob I]

"Format, Sheet, Hide"

 

[Don Guillett]

But then the user can just as easily unhide UNLESS you use a macro to make
the sheet VERYhidden

 

[Bill Ridgeway]

There are various ways to hide information in a worksheet. They are not all
practical and will not deter the determined or adventurous. Indeed even
password protection can be cracked in minutes.

Change text AND background colour to, say, white.

Click on <Format><Sheet><Hide>

Reduce all columns width and rows height to 1.

Why not all three (and any others that come to mind)? That'll keep them
guessing for a while!

Always keep a backup so that, if anyone broke in and changed information, by
accident or intent, you can restore the situation very easily. It is good
to trust colleagues but it is also good to be aware that they may not all be
trustworthy.

Regards.

Bill Ridgeway
Computer Solutions