How to Unhide Very Hidden Sheets in Excel (2 Effective Methods)

Sometimes your worksheet may contain confidential information and in that case, hiding your worksheet may be one of the best options. Excel also gives you access to unhide your hidden sheets or very hidden sheets. In this article, I am going to illustrate the method of how to unhide very hidden sheets in Excel.


Download Practice Workbook

You can download the practice book from the button below.


What Is Very Hidden Sheet in Excel?

Excel provides us with the features to hide the rows and the columns, the cell values, and even the whole worksheet. But there is some difference between a hidden worksheet and a very hidden worksheet. In the case of a hidden worksheet, when you right-click on the mouse on any active sheet, the Unhide option will be visible in the list. Excel allows you to unhide the hidden sheets just by clicking this option.

Unhide Very Hidden Sheets in Excel

But in the case of a very hidden sheet, it’s a little bit different. Here, if you right-click on the mouse, Excel won’t give you access to use the Unhide option.

Unhide Very Hidden Sheets in Excel


2 Effective Methods to Unhide Very Hidden Sheets in Excel

You have seen that in the case of a very hidden sheet, you can’t use the Unhide option. Rather you should look for different methods. In this section, you will find 2 effective methods to unhide the very hidden sheets in Excel. Here, I will try to demonstrate them one by one.


1. Changing Visible Property to Unhide Hidden Sheets

Let’s say, in our workbook, one sheet is hidden. We want to unhide the hidden sheet.

Unhide Very Hidden Sheets in Excel

In order to illustrate this method, proceed with the following steps.

Steps:

  • First of all, right-click on the mouse just to check whether the sheet is just hidden or verily hidden. The Unhide option is disabled for the very hidden sheets.

Unhide Very Hidden Sheets in Excel

  • Now, press ALT+F11 to open the VBA window and select the very hidden sheet.

Unhide Very Hidden Sheets in Excel

  • Then, press F4 (or go to the View tab and select properties window) to open the visible properties. You will see that the visible property is set to xlSheetVeryHidden.

Unhide Very Hidden Sheets in Excel

  • Now, change it to xlSheetVisible to unhide the very hidden sheet.

Note: You can select the xlSheetHidden option instead of this and then you will get the Unhide option from the context menu to hide the very hidden sheet, but that sounds tedious and inefficient. 

  • Finally, you will see that your very hidden sheet has appeared in your Excel workbook.

In this way, you can easily unhide the very hidden sheets in your Excel File.

Read More: [Fixed!] Unable to Set the Visible Property of the Worksheet Class


2. Use VBA to Unhide Very Hidden Sheets

You can also use the VBA code to unhide the very hidden sheets in your Excel file. In order to do so, follow the steps below.

Steps:

  • Firstly, press CTRL+F11 to open the VBA window.

  • Then, right-click on the very hidden sheet> select Insert> click Module.

  • Now, the Module or Code window will appear on the screen. Enter the code for unhiding the very hidden sheets. You can use the following:
Sub UnhidingVeryHiddenSheets()
Dim works As Worksheet

For Each works In Worksheets
If works.Visible = xlSheetVeryHidden Then works.Visible = xlSheetVisible
Next

End Sub

  • After that, save your workbook as a macro-enabled file and press ALT+Q to switch back to the Excel sheet.
  • Here, press ALT+F8 to open the Macro dialogue box. Select the Macro name> click Run.

  • Hence, your very hidden sheet will be unhidden and show up in your workbook.

Unhide Very Hidden Sheets in Excel

Read More: How to Unhide All Sheets in Excel Using VBA (4 Examples)


Things to Remember

  • A sheet can be very hidden only by using VBA.
  • A very hidden sheet can not be unhidden without the help of the Visual Basic Editor window.
  • The Unhide option is only available when your worksheet is just simply hidden. So, if you can turn the very hidden sheet into hidden then you will get the Unhide option.
  • All worksheets can not be hidden at the same time. At least one worksheet must be visible in the Excel file.

Conclusion

In this article, I have tried to show you some methods of how to unhide very hidden sheets in Excel. I hope this tutorial has eased your way to unhide very hidden sheets in an Excel workbook to some extent. Thanks for reading this article. If you have better methods, questions, or feedback regarding this article, please don’t forget to share them in the comment box. For more queries, kindly visit our website ExcelDemy. Have a great day!


Related Articles

Rafi

Rafi

Hey there! I am Md. Rafiul Hasan. Currently I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our worktime and made it easy for us to quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo