I have inadvertently "hidden" the worksheet tabs at the bottom of an Excel spreadsheet file. How do I "unhide" the tabs so I can access my worksheets. I would appreciate your assistance in resolving this. Thanks in advance!
Answers (1)
I believe you right-clicked on the sheet name, then selected "hide." To unhide:
1. Enable the Developer tab and Open up Visual Basic.
2. In the Project Window select your sheet
3. In the Properties Window select the property "Visible." It likely says "0 - xlSheetHidden"
4. Change this to "-1 xlSheetVisible."
This is how you enable the Developer tab:
1. File
2. Options
3. Customize Ribbon
4. Check "Developer"
In Visual Basic, the Properties and Project Windows should be visible by default. If they are not:
1. View > Project Explorer
2. View > Properties Window