troubleshooting Question

Can't view sheets even after unhiding all sheets.....VeryHidden???

Avatar of ghoshsaikat83
ghoshsaikat83 asked on
Microsoft Excel
6 Comments1 Solution1879 ViewsLast Modified:

Someone has mailed me an excel file. In the file I can see that he has given rerefence to a number os sheets but I can't view them. I tried to unhide all sheets, but excel says that there are no hidden sheets. When I am looking at the VBA Project list, I can see a lot of sheets which are just not apprearing in the Sheet Tabs even though there aren't any hidden cells. In the vba project I can see that he has used the below mentioned code. The sheets mentioned in the code are the ones which I can't view. I wan't to how to do that and how to undo that.
Private Sub Workbook_Open()

Dim x As Date
Dim y As Date
x = Date
y = #2/23/2010#
If x >= y Then
Sheets("Master").Visible = xlVeryHidden

Sheets("TL Data").Visible = xlVeryHidden
Sheets("ES").Visible = xlVeryHidden
Sheets("Project").Visible = xlVeryHidden
Sheets("TS").Visible = xlVeryHidden
Sheets("TS Report").Visible = xlVeryHidden
Sheets("ES Report").Visible = xlVeryHidden
Sheets("Project Report").Visible = xlVeryHidden
Sheets("2COMS").Visible = xlVeryHidden


End If
End Sub
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros