Forum Discussion
Hide Sheet after missusing shortcut Alt+H+W
I was working on an inventory and frequently using the shortcut mentioned above. Unfortunately, during one of those times, I must have misused it, and my sheet became hidden. Since then, I’ve tried m...
Try this:
1: Try the standard unhide
- Right‑click on any visible sheet tab at the bottom.
- Select Unhide….
- If your missing sheet is listed, select it and click OK.
If it’s not listed, that means it’s “Very Hidden.”
2: Use the VBA editor to unhide “Very Hidden” sheets
- Press Alt + F11 to open the VBA editor.
- In the left pane (Project Explorer), expand your workbook.
- Select the sheet you can’t see.
- In the Properties window (press F4 if it’s not visible), look for the property Visible.
- Change it from xlSheetVeryHidden to xlSheetVisible.
- Close the VBA editor and return to Excel—the sheet should now be visible.
3: Check workbook protection
If the sheet still won’t unhide:
- Go to Review → Protect Workbook.
- If protection is enabled, you may need the password to unprotect before unhiding sheets.