Generally, when you hide a excel sheet in the following method. The hide does disappear but can be easily unhidden unless you have protected the workbook.
Using the VBA environment, it is possible to hide sheet where in one cannot unhide it using the normal unhide user interface.
Below is the method.
1. Hit Alt+F11, you will be presented with a screen like below.
2. Now click on the sheet which you would want to "deep hide" in the top left section. Now in the bottom left section which has the sheet properties (as shown below), click on drop down next to "Visible". Select 2.- xlSheetVeryHidden option. Close the window.
3. Now the sheet which was hid using VBA window "Sheet 2" is not available for unhiding.
But you would need to be careful to remember that there is a sheet which is "deep hidden".
Thanks for visiting. If you have any questions reach out to me directly at askme.kkhelps@gmail.com
No comments:
Post a Comment