Sometimes some sheets in the book have to be hidden from the eyes of users. The classic way involves hiding the sheet through the menu Format – Sheet – Hide or right-click on the sheet tab – Hide (Hide):
The problem is that the user, having entered the menu Format – Sheet – Displayor by right-clicking on any sheet’s tab and selecting Show (Unhide), will see the names of hidden sheets and understand that some information is hidden from it:
Therefore, it is better to make sure that the user does not even know about the presence of some hidden sheets in the book. To do this, open the Visual Basic editor:
- in Excel 2003 and later, by selecting from the menu Service – Macro – Visual Basic Editor (Tools — Macro — Visual Basic Editor)
- in Excel 2007 and newer – by clicking on the button Visual Basic editor (Visual Basic Editor) tab developer (Developer) or by clicking ALT + F11
We are looking for the following window on the screen:
If it is not visible, then you can display it through the menu View — Project Explorer (top) and View — Properties Window (Bottom part).
In the upper part on the “tree” we find and select our sheet (in the picture – Sheet1), and in the lower part we find the property Visible (at the end of the list) and do it xlSheetVeryHidden.
Voila! Now you can see this sheet and learn about its existence only in the Visual Basic editor and it will not be displayed in any Excel windows and menus. The less you know the better you sleep. 🙂
- 4 levels of protection in Excel files
- Hiding sheets in bulk with the PLEX add-on