Unhiding worksheets

Giganews Newsgroups
Subject: Unhiding worksheets
Posted by:  oldjay
Date: Tue, 16 May 2006

I have a workbook with several "well" hidden worksheets.
They don't appear in the project explorer or on the toolbar menu
Someone in the group gave the following marco to unhide them

Sub Macro1()
For Each Sheet In Sheets
On Error Resume Next
Sheet.Visible = True
Next
End Sub

It gives the following error
"can't find project or library" and hi-lights the first "sheet"

oldjay

Replies