Unhiding worksheets
 

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

Unhiding worksheets
 

FORMAT - SHEET - UNHIDE

"Oldjay" wrote:

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

Unhiding worksheets
 

goto the vb editortoolsreferenceslook for missing

--
Don Guillett
SalesAid Software

"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

Unhiding worksheets
 

This only shows the regular hidden sheets

"James Hamilton" wrote:

FORMAT - SHEET - UNHIDE

"Oldjay" wrote:

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

Unhiding worksheets
 

I can't find a reference "look for missing". I also "browed" the references

"Don Guillett" wrote:

goto the vb editortoolsreferenceslook for missing

--
Don Guillett
SalesAid Software

"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

Unhiding worksheets
 

Don wanted you to click on Tools|references
and look for a missing reference.

If you have a reference marked as missing, then uncheck it and try your code
once more.

Oldjay wrote:

I can't find a reference "look for missing". I also "browed" the references

"Don Guillett" wrote:

goto the vb editortoolsreferenceslook for missing

--
Don Guillett
SalesAid Software

"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





--

Dave Peterson

Unhiding worksheets
 

I don't see anything that says "missing reference", Please give me a more
detailed instruction
Thanks

"Dave Peterson" wrote:

Don wanted you to click on Tools|references
and look for a missing reference.

If you have a reference marked as missing, then uncheck it and try your code
once more.

Oldjay wrote:

I can't find a reference "look for missing". I also "browed" the references

"Don Guillett" wrote:

goto the vb editortoolsreferenceslook for missing

--
Don Guillett
SalesAid Software

"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





--

Dave Peterson

Unhiding worksheets
 

I have found the problem. Thanks for replying

oldjay

"Oldjay" wrote:

I don't see anything that says "missing reference", Please give me a more
detailed instruction
Thanks

"Dave Peterson" wrote:

Don wanted you to click on Tools|references
and look for a missing reference.

If you have a reference marked as missing, then uncheck it and try your code
once more.

Oldjay wrote:

I can't find a reference "look for missing". I also "browed" the references

"Don Guillett" wrote:

goto the vb editortoolsreferenceslook for missing

--
Don Guillett
SalesAid Software

"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





--

Dave Peterson

Unhiding worksheets
 

Care to share the final solution for the archives

--
Don Guillett
SalesAid Software

"Oldjay" wrote in message
...
I have found the problem. Thanks for replying

oldjay

"Oldjay" wrote:

I don't see anything that says "missing reference", Please give me a more
detailed instruction
Thanks

"Dave Peterson" wrote:

Don wanted you to click on Tools|references
and look for a missing reference.

If you have a reference marked as missing, then uncheck it and try your
code
once more.

Oldjay wrote:

I can't find a reference "look for missing". I also "browed" the
references

"Don Guillett" wrote:

goto the vb editortoolsreferenceslook for missing

--
Don Guillett
SalesAid Software

"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





--

Dave Peterson

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