software

I have a workbook with several quot;wellquot; 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
quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;

oldjayFORMAT -gt; SHEET -gt; UNHIDE

quot;Oldjayquot; wrote:

gt; I have a workbook with several quot;wellquot; hidden worksheets.
gt; They don't appear in the project explorer or on the toolbar menu
gt; Someone in the group gave the following marco to unhide them
gt;
gt; Sub Macro1()
gt; For Each Sheet In Sheets
gt; On Error Resume Next
gt; Sheet.Visible = True
gt; Next
gt; End Sub
gt;
gt; It gives the following error
gt; quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;
gt;
gt; oldjay
gt;

goto the vb editorgt;toolsgt;referencesgt;look for missing

--
Don Guillett
SalesAid Software

quot;Oldjayquot; gt; wrote in message
...
gt;I have a workbook with several quot;wellquot; hidden worksheets.
gt; They don't appear in the project explorer or on the toolbar menu
gt; Someone in the group gave the following marco to unhide them
gt;
gt; Sub Macro1()
gt; For Each Sheet In Sheets
gt; On Error Resume Next
gt; Sheet.Visible = True
gt; Next
gt; End Sub
gt;
gt; It gives the following error
gt; quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;
gt;
gt; oldjay
gt;
This only shows the regular hidden sheets

quot;James Hamiltonquot; wrote:

gt; FORMAT -gt; SHEET -gt; UNHIDE
gt;
gt; quot;Oldjayquot; wrote:
gt;
gt; gt; I have a workbook with several quot;wellquot; hidden worksheets.
gt; gt; They don't appear in the project explorer or on the toolbar menu
gt; gt; Someone in the group gave the following marco to unhide them
gt; gt;
gt; gt; Sub Macro1()
gt; gt; For Each Sheet In Sheets
gt; gt; On Error Resume Next
gt; gt; Sheet.Visible = True
gt; gt; Next
gt; gt; End Sub
gt; gt;
gt; gt; It gives the following error
gt; gt; quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;
gt; gt;
gt; gt; oldjay
gt; gt;

I can't find a reference quot;look for missingquot;. I also quot;browedquot; the references

quot;Don Guillettquot; wrote:

gt; goto the vb editorgt;toolsgt;referencesgt;look for missing
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Oldjayquot; gt; wrote in message
gt; ...
gt; gt;I have a workbook with several quot;wellquot; hidden worksheets.
gt; gt; They don't appear in the project explorer or on the toolbar menu
gt; gt; Someone in the group gave the following marco to unhide them
gt; gt;
gt; gt; Sub Macro1()
gt; gt; For Each Sheet In Sheets
gt; gt; On Error Resume Next
gt; gt; Sheet.Visible = True
gt; gt; Next
gt; gt; End Sub
gt; gt;
gt; gt; It gives the following error
gt; gt; quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;
gt; gt;
gt; gt; oldjay
gt; gt;
gt;
gt;
gt;

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:
gt;
gt; I can't find a reference quot;look for missingquot;. I also quot;browedquot; the references
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt; gt; goto the vb editorgt;toolsgt;referencesgt;look for missing
gt; gt;
gt; gt; --
gt; gt; Don Guillett
gt; gt; SalesAid Software
gt; gt;
gt; gt; quot;Oldjayquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I have a workbook with several quot;wellquot; hidden worksheets.
gt; gt; gt; They don't appear in the project explorer or on the toolbar menu
gt; gt; gt; Someone in the group gave the following marco to unhide them
gt; gt; gt;
gt; gt; gt; Sub Macro1()
gt; gt; gt; For Each Sheet In Sheets
gt; gt; gt; On Error Resume Next
gt; gt; gt; Sheet.Visible = True
gt; gt; gt; Next
gt; gt; gt; End Sub
gt; gt; gt;
gt; gt; gt; It gives the following error
gt; gt; gt; quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;
gt; gt; gt;
gt; gt; gt; oldjay
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

I don't see anything that says quot;missing referencequot;, Please give me a more
detailed instruction
Thanks

quot;Dave Petersonquot; wrote:

gt; Don wanted you to click on Tools|references
gt; and look for a missing reference.
gt;
gt; If you have a reference marked as missing, then uncheck it and try your code
gt; once more.
gt;
gt; Oldjay wrote:
gt; gt;
gt; gt; I can't find a reference quot;look for missingquot;. I also quot;browedquot; the references
gt; gt;
gt; gt; quot;Don Guillettquot; wrote:
gt; gt;
gt; gt; gt; goto the vb editorgt;toolsgt;referencesgt;look for missing
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Don Guillett
gt; gt; gt; SalesAid Software
gt; gt; gt;
gt; gt; gt; quot;Oldjayquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;I have a workbook with several quot;wellquot; hidden worksheets.
gt; gt; gt; gt; They don't appear in the project explorer or on the toolbar menu
gt; gt; gt; gt; Someone in the group gave the following marco to unhide them
gt; gt; gt; gt;
gt; gt; gt; gt; Sub Macro1()
gt; gt; gt; gt; For Each Sheet In Sheets
gt; gt; gt; gt; On Error Resume Next
gt; gt; gt; gt; Sheet.Visible = True
gt; gt; gt; gt; Next
gt; gt; gt; gt; End Sub
gt; gt; gt; gt;
gt; gt; gt; gt; It gives the following error
gt; gt; gt; gt; quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;
gt; gt; gt; gt;
gt; gt; gt; gt; oldjay
gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I have found the problem. Thanks for replying

oldjay

quot;Oldjayquot; wrote:

gt; I don't see anything that says quot;missing referencequot;, Please give me a more
gt; detailed instruction
gt; Thanks
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Don wanted you to click on Tools|references
gt; gt; and look for a missing reference.
gt; gt;
gt; gt; If you have a reference marked as missing, then uncheck it and try your code
gt; gt; once more.
gt; gt;
gt; gt; Oldjay wrote:
gt; gt; gt;
gt; gt; gt; I can't find a reference quot;look for missingquot;. I also quot;browedquot; the references
gt; gt; gt;
gt; gt; gt; quot;Don Guillettquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; goto the vb editorgt;toolsgt;referencesgt;look for missing
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Don Guillett
gt; gt; gt; gt; SalesAid Software
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Oldjayquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt;I have a workbook with several quot;wellquot; hidden worksheets.
gt; gt; gt; gt; gt; They don't appear in the project explorer or on the toolbar menu
gt; gt; gt; gt; gt; Someone in the group gave the following marco to unhide them
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Sub Macro1()
gt; gt; gt; gt; gt; For Each Sheet In Sheets
gt; gt; gt; gt; gt; On Error Resume Next
gt; gt; gt; gt; gt; Sheet.Visible = True
gt; gt; gt; gt; gt; Next
gt; gt; gt; gt; gt; End Sub
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; It gives the following error
gt; gt; gt; gt; gt; quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; oldjay
gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

Care to share the final solution for the archives

--
Don Guillett
SalesAid Software

quot;Oldjayquot; gt; wrote in message
...
gt;I have found the problem. Thanks for replying
gt;
gt; oldjay
gt;
gt; quot;Oldjayquot; wrote:
gt;
gt;gt; I don't see anything that says quot;missing referencequot;, Please give me a more
gt;gt; detailed instruction
gt;gt; Thanks
gt;gt;
gt;gt; quot;Dave Petersonquot; wrote:
gt;gt;
gt;gt; gt; Don wanted you to click on Tools|references
gt;gt; gt; and look for a missing reference.
gt;gt; gt;
gt;gt; gt; If you have a reference marked as missing, then uncheck it and try your
gt;gt; gt; code
gt;gt; gt; once more.
gt;gt; gt;
gt;gt; gt; Oldjay wrote:
gt;gt; gt; gt;
gt;gt; gt; gt; I can't find a reference quot;look for missingquot;. I also quot;browedquot; the
gt;gt; gt; gt; references
gt;gt; gt; gt;
gt;gt; gt; gt; quot;Don Guillettquot; wrote:
gt;gt; gt; gt;
gt;gt; gt; gt; gt; goto the vb editorgt;toolsgt;referencesgt;look for missing
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; --
gt;gt; gt; gt; gt; Don Guillett
gt;gt; gt; gt; gt; SalesAid Software
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; quot;Oldjayquot; gt; wrote in message
gt;gt; gt; gt; gt; ...
gt;gt; gt; gt; gt; gt;I have a workbook with several quot;wellquot; hidden worksheets.
gt;gt; gt; gt; gt; gt; They don't appear in the project explorer or on the toolbar menu
gt;gt; gt; gt; gt; gt; Someone in the group gave the following marco to unhide them
gt;gt; gt; gt; gt; gt;
gt;gt; gt; gt; gt; gt; Sub Macro1()
gt;gt; gt; gt; gt; gt; For Each Sheet In Sheets
gt;gt; gt; gt; gt; gt; On Error Resume Next
gt;gt; gt; gt; gt; gt; Sheet.Visible = True
gt;gt; gt; gt; gt; gt; Next
gt;gt; gt; gt; gt; gt; End Sub
gt;gt; gt; gt; gt; gt;
gt;gt; gt; gt; gt; gt; It gives the following error
gt;gt; gt; gt; gt; gt; quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;
gt;gt; gt; gt; gt; gt;
gt;gt; gt; gt; gt; gt; oldjay
gt;gt; gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt;
gt;gt; gt; Dave Peterson
gt;gt; gt;
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
----------------------------------------------------------------------------
---------

quot;Oldjayquot; gt; wrote in message
...
gt; I have a workbook with several quot;wellquot; hidden worksheets.
gt; They don't appear in the project explorer or on the toolbar menu
gt; Someone in the group gave the following marco to unhide them
gt;
gt; Sub Macro1()
gt; For Each Sheet In Sheets
gt; On Error Resume Next
gt; Sheet.Visible = True
gt; Next
gt; End Sub
gt;
gt; It gives the following error
gt; quot;can't find project or libraryquot; and hi-lights the first quot;sheetquot;
gt;
gt; oldjay
gt;