MrExcel.com - Your One Stop for Excel Tips & Solutions

Very Hide a Worksheet

October 05, 2023 - by

Very Hide a Worksheet

Problem: I don’t want people unhiding my worksheets. I have one guy in accounting who always goes to Home, Format, Hide and Unhide, Worksheets to see what is hidden.

Strategy: There is a Very Hidden setting. Worksheets that are Very Hidden will not appear in the Unhide Worksheets dialog.

To change a worksheet to Very Hidden, follow these steps:

  • 1. Press Alt+F11 to open VBA.

  • 2. Press Ctrl+R to open the Project Explorer pane.

  • 3. Find your workbook in the Projects list. If you can’t see the worksheets under the Workbook, use the + icon to the left of your workbook. If necessary, click the + sign next to Microsoft Excel Objects so you can see the list of worksheets.

  • 4. Click once on the worksheet name you want to hide.

  • 5. Press F4 to display the Properties pane.

  • 6. Open the dropdown for Visible and choose 2 - xlSheetVeryHidden.

  • 7. Alt+Q to close VBA and return to Excel.

In the Project Explorer, click on Sheet3
Figure 1352. Expand the tree view until you find the worksheet that you want to hide.
Find the Visible property. The three choices are xlSheetVisible xlSheetHidden xlSheetVeryHidden
Figure 1353. Change to Very Hidden.

This article is an excerpt from Power Excel With MrExcel

Title photo by Shubham Dhage on Unsplash