Cannot Unhide Worksheets

[healynorton]

Today I opened a spreadsheet that I haven't referenced in 6+ months. There are 2 worksheets that I know are there, but I can't make them visible.

How do I know they're there? (1) there are formulas in the worksheet I can see that references the hidden ones and (2) when I try to create a new worksheet with the same name, Excel tells me it already exists.

There are no macros in the file.

Any thoughts?

Thanks!
-Kathy

 

[dave3009]

These sheets will probably have been set to xlVeryHidden

Press alt+F11 to open the VBE, look for the project on the left and locate the hidden sheets, look at the properties for these sheets and change them to xlVisible

 

[kpark91]

right click on your worksheet tab > unhide > select worksheets to unhide > ok.

Does that work for you?
If it doesn't use this code in your VBE and run it

Sub UnhideAllWorksheets()
    For i = 1 To Worksheets.Count
        Worksheets(i).Visible = True
    Next i
End Sub

 

[healynorton]

Thanks! Right clicking on the tabs did it!