Hiding sheets is a very common feature that we use. If we hide some sheets then unhiding them is not a big deal and you can get them back through "Unhide Sheets" option.
At times, sheets are hidden but we are unable to unhide them directly. This happens if we hide them through VBA editor or using VBA Code.
You can set Visible property of a sheet to xlSheetVeryHidden and user won't be able to unhide that sheet directly through "Unhide Sheets" option.
Sometime we see error while unhiding our sheet through VBA Editor. The error is shown below:
This happens if the sheet (or workbook) is protected. You need to first unprotect it to get rid of this error.
Stay tuned to Our Blog for more Tips and Tricks in Excel. Also Subscribe to our Youtube channel for video tutorials.
