Unhiding worksheets
In Excel, go to Tools, Macros, Visual Basic Editor
In the properties window, there is a Visible Property with 3 settings:
Visible, Hidden and Very Hidden.
The very hidden CANNOT be unhidden from just inside Excel, you have to use
the Visual Basic Editor
Saruman
----------------------------------------------------------------------------
---------
All Outgoing Mail Checked With Norton Antivirus 2003
----------------------------------------------------------------------------
---------
"Oldjay" wrote in message
...
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
|