| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
| Unhiding All hidden Worksheets with a Macro/VBA Code | Excel Discussion (Misc queries) | |||
| Unhiding multiple worksheets in Excel 2000 | Excel Worksheet Functions | |||
| Unhiding worksheets | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
