|Office Tutorials & Software Solutions|
|Specializing in Advanced Spreadsheet & Office Macro Solutions.
|SUPERHIDE Microsoft® Excel sheets|
|Tested on versions:||2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97|
Hiding Excel sheets is very useful to protect content, either for privacy/security reasons or for pure precaution - avoiding users messing, even involuntary, with complex data like lookup tables. But if you really want to protect the hidden content, you need to prevent users from unhiding it.
Regularly hidding/unhidding excel sheets - Using the trick EVERYBODY knows
There is a regular way to hide Excel sheets. It is very simple but the problem with it is that almost everyone knows how to unhide them - It is also easy. And, if they don't know, all they need to do is to search Excel help for "unhide sheet". To hide a Sheet, all you need to do is:
But anyone can unhide it again:
New Privacy Level 1 - Using the trick nobody knows
There is, however, a trick that almost nobody knows because it demands utilization of an Excel feature most people don't know how to use, even if they know it exists - The Macro editor. To use it to hide an Excel sheet, you need to do this:
New Privacy Level 2 - Password protecting the trick nobody knows
Level 1 privacy will work for most people because they will not know how to unhide the sheet. They will try the traditional way but nothing will appear on the unhide box so they will be lost. But if they search for help, on the web as a instance, they may find how to unhide it. In fact, they may find this very article on a search engine!
There is a solution for this - Set a password for the macro editor. users will be prompted for the password before they can access the sheet properties, so they cannot change them without either knowing the password or braking it - an hacker, not user, task.
To set a password for the macro editor, do this:
Unhidden it again
Is there any way of unhidden the sheet after this? Of course, doing this:
It is also possible to delete the macro editor password:
Can I know more about this subject ?
Check our FREE PC Tips and Tutorials. They will be regularly published. Better still, subscribe our Email Newsletter. You will be informed when contents updates are made and automatically granted participation on any future promotion.
(c) 2004 - 2020 OfficeHelp.Biz