EXCEL ERROR : Unable to set the Visible property of the Worksheet class

We usually hide our sheets to limit the access.Though unhiding them is not tough and you just need to click on Sheets Tab and revert from "Unhide Sheets" option.

Sometimes 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.