Excel very hidden sheets are worksheets that do not appear on the sheet-tab bar and cannot be restored through Excel’s standard Unhide dialog. In Microsoft 365 for Windows, you can make one very hidden or visible from the Visual Basic Editor by changing its Visible property; this hides it from casual view, but does not secure its contents.
What a very hidden sheet is
Excel gives a worksheet a visibility setting. A visible worksheet has a tab, a normally hidden worksheet can be brought back with the Unhide command, and a very hidden worksheet is omitted from that command. The very hidden state is an Excel object-model setting, commonly represented in VBA as xlSheetVeryHidden. It is useful when a workbook has supporting sheets that most users should not need to navigate to.
All three states concern whether a worksheet is shown as a tab; they are not the same as hiding rows or columns. A hidden worksheet remains part of the workbook, and formulas can continue to refer to cells on it. For example, a visible summary sheet can display a total calculated from a very hidden data sheet. The data is still in the file.
How very hidden differs from ordinary hidden
For an ordinary hidden worksheet, a user can usually right-click a sheet tab, choose Unhide, select the sheet, and confirm. In Excel for Microsoft 365 on Windows, the equivalent ribbon command is Home > Format > Hide & Unhide > Unhide Sheet. A very hidden worksheet does not appear in that list, so those routes cannot reveal it.
The important difference is discoverability, not protection. Both types remain in the workbook. A user who can open the Visual Basic Editor and change the worksheet’s Visible property can make a very hidden sheet visible, unless workbook restrictions prevent the change. The property is not a password and does not encrypt the sheet.
How to make a worksheet very hidden
Use desktop Excel to change the setting. Save a backup first, particularly if the workbook is important or shared. Then follow these steps in Excel for Microsoft 365 on Windows:
- Open the workbook and choose Developer > Visual Basic. If Developer is missing, enable it through File > Options > Customize Ribbon, then select Developer.
- In the Visual Basic Editor, locate the correct workbook in Project Explorer. Expand its Microsoft Excel Objects folder and select the worksheet, checking the sheet name shown in parentheses so you do not select the wrong one.
- Open the Properties window with View > Properties Window, or press F4 after selecting the worksheet object.
- Find the Visible property and choose
2 - xlSheetVeryHiddenfrom its choices. Close the editor and return to Excel; the sheet tab should no longer appear.
To make the sheet ordinary hidden instead, choose 0 - xlSheetHidden. To show it, choose -1 - xlSheetVisible. These values correspond to the Excel constants xlSheetHidden, xlSheetVisible, and xlSheetVeryHidden; using the named constants in VBA is easier to read than memorizing the numbers.
How to restore a very hidden sheet
Open the Visual Basic Editor again, select the worksheet object in the correct workbook, and change Visible to -1 - xlSheetVisible. The worksheet tab will return. If you only want to make it available through the normal Unhide dialog, set it to 0 - xlSheetHidden instead. Once it is visible, you can also use Excel’s ordinary hide and unhide commands.
Excel requires at least one worksheet to remain visible. If the workbook has only one visible worksheet, do not set that last visible sheet to hidden or very hidden without first making another sheet visible. Otherwise Excel cannot leave the workbook with no visible worksheet.
Changing visibility with VBA
For a repeated task, a short macro can set the property. Put this code in a standard module in the workbook that contains the Support worksheet, and replace Support with the exact worksheet tab name if needed. Save a copy before running it: macros can change workbook contents and their actions cannot be reversed with Ctrl+Z.
Sub MakeSupportVeryHidden()
Dim ws As Worksheet
' Change Support to the exact worksheet tab name.
Set ws = ThisWorkbook.Worksheets("Support")
ws.Visible = xlSheetVeryHidden
End Sub
To restore the same sheet with a macro, use this separate procedure:
Sub ShowSupportSheet()
Dim ws As Worksheet
' Change Support to the exact worksheet tab name.
Set ws = ThisWorkbook.Worksheets("Support")
ws.Visible = xlSheetVisible
End Sub
ThisWorkbook means the workbook containing the macro, so put the code in the workbook you intend to change. If you keep VBA code in the workbook, save it in a macro-enabled format such as .xlsm; the standard .xlsx format does not retain VBA macros. You can still use the Visual Basic Editor’s Properties window to set visibility without adding a macro.
When very hidden sheets are useful
Very hidden sheets can keep a workbook’s main interface uncluttered. For example, a workbook might show a Dashboard and Input tabs while keeping a lookup table or calculation sheet out of the ordinary Unhide list. A template author might use the setting for background instructions or supporting lists that are not part of the user’s usual workflow.
It is most appropriate when the goal is to reduce accidental navigation or discourage casual changes, not to conceal sensitive information. Consider documenting which sheet is intentionally hidden and how an authorized maintainer can restore it. Otherwise, a future editor may mistake the sheet for missing content or spend time troubleshooting formulas that depend on it.
Very hidden sheets and workbook protection
Workbook structure protection is separate from sheet visibility. In Excel, Review > Protect Workbook can restrict structural changes such as adding, deleting, moving, renaming, hiding, and unhiding sheets through normal commands. If the workbook’s structure is protected, Excel may prevent a visibility change until an authorized person removes that protection with the password. A password used for workbook structure protection is not the same as encryption of the file.
Neither very hidden status nor structure protection should be treated as a confidentiality boundary. Someone with access to the workbook may be able to inspect its contents using other tools or authorized VBA access. If information must be kept private, do not distribute it inside a workbook to people who should not see it. For file access controls, use appropriate storage permissions or Excel’s file-encryption option, and follow your organization’s security requirements.
Excel for Mac and Excel for the web
The worksheet visibility property and VBA constants are Excel features, but the steps for opening the editor can differ by platform. In Excel for Mac, use Developer > Visual Basic when the Developer tab is available; keyboard shortcuts can vary with the keyboard and function-key settings. The Visual Basic Editor provides the worksheet Properties window for changing visibility. If you cannot find the tab, check Excel’s ribbon and toolbar settings.
Excel for the web does not provide the desktop Visual Basic Editor or run VBA macros. If you need to set or change a very hidden state, open the workbook in the desktop Excel application. Web capabilities for worksheets hidden in a desktop workbook can differ, so do not rely on the browser as the way to manage very hidden sheets.
Common problems and checks
- The sheet is missing from Unhide: That is expected if it is very hidden. Use the Visual Basic Editor and set its Visible property to
-1 - xlSheetVisible. - The property cannot be changed: Check whether workbook structure protection is active, whether you selected the right workbook and worksheet, and whether you have permission to edit the file.
- The macro reports that it cannot find the sheet: Confirm the worksheet tab name matches the text in the code. Spaces and punctuation matter. Also confirm the macro is running from the workbook referenced by
ThisWorkbook. - The tab returns but formulas still seem wrong: Visibility does not change cell values or formulas. Check the referenced ranges, calculation settings, and whether the underlying source data is present.
- The macro disappears after saving: Check that the workbook was saved as
.xlsmrather than.xlsx. The latter cannot store a VBA project.
Frequently Asked Questions
Can I unhide a very hidden sheet without VBA?
Yes. You can use the Visual Basic Editor’s Properties window and set Visible to -1 - xlSheetVisible. You do not need to write or run a macro to make that change.
Can someone still see data on a very hidden sheet?
Yes. Very hidden only removes the worksheet from the tab bar and the standard Unhide list. It does not encrypt or securely erase the sheet’s data.
Does a very hidden sheet still calculate?
Yes. Formulas can refer to cells on hidden and very hidden worksheets, and those references continue to work while the sheet is hidden.
Can I make every worksheet very hidden?
No. Excel requires at least one worksheet to remain visible. Make another sheet visible before changing the last visible worksheet’s state.
Does very hidden work in Excel for the web?
The web app does not include the desktop Visual Basic Editor or run VBA. Use desktop Excel to manage the Visible property, especially when you need to restore a very hidden sheet.
Related
- Excel Min Sec Format: Display Minutes and Seconds
- Small Excel Table: Create, Format, and Use One
- Small Excel Sample Data: Examples to Copy and Use Now
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Find and Replace Asterisk CharactersTo find a literal asterisk in Excel for Microsoft 365 on Windows, press Ctrl+H, enter ~* in Find…
- How to Delete a Page in Word in SharePointTo remove a page from a Word document stored in SharePoint, open the file in Word, select the…
- How to Double Space in Word for the Web: A Quick GuideTo double-space text in Word for the web, select the text, open Home > Line and Paragraph Spacing,…
- Change Your Calendar View in Outlook: A Step-by-Step GuideTo change your calendar view in Outlook, open Calendar and choose Day, Work week, Week, or Month from…
- Excel Heat Maps: How to Create, Customize, and Read ThemTo create a heat map in Excel for Microsoft 365 on Windows, select the numeric cells you want…
- How to Share a Group Calendar in Outlook 365 With MembersTo share a Microsoft 365 group calendar in Outlook, add the people who need access as members of…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.