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.
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.
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 Possible Solutions
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.
In order to illustrate this method, proceed with the following steps.
- First of all, right-click on the mouse just to check whether the sheet is hidden or verily hidden. The Unhide option is disabled for the very hidden sheets.
- Now, press ALT+F11 to open the VBA window and select the very hidden sheet.
- Then, press F4 (or go to the View tab and select the properties window) to open the visible properties. You will see that the visible property is set to xlSheetVeryHidden.
- 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.
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.
- 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.
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 simply hidden. So, if you can turn the very hidden sheet into a 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.
Download Practice Workbook
You can download the practice book from the button below.
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.