| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to show hidden sheets?
Greeting,
Is there any code to show all hidden sheets in worksheet? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to show hidden sheets?
Unless they are xlveryhidden you don't need code, simply unhide them with
Format|sheet|Unhide Mike "ghost" wrote: Greeting, Is there any code to show all hidden sheets in worksheet? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to show hidden sheets?
For Each sh In ACtiveworkbook.Worksheets
sh.Visible = xlSheetVisible Next sh -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ghost" wrote in message ... Greeting, Is there any code to show all hidden sheets in worksheet? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to show hidden sheets?
hi
as in vb code? Dim WS As Worksheet For Each WS In Worksheets WS.Visible = True Next WS untested. watch for typos regards FSt1 "ghost" wrote: Greeting, Is there any code to show all hidden sheets in worksheet? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to show hidden sheets?
Hi Mike and thank you for response
When I go to Microsoft VB, Worksheet project has 25 sheets, while in the sheet tab; there are five sheets only, Please advice? Thank you again "Mike H" wrote: Unless they are xlveryhidden you don't need code, simply unhide them with Format|sheet|Unhide Mike "ghost" wrote: Greeting, Is there any code to show all hidden sheets in worksheet? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks to hidden sheets | Excel Discussion (Misc queries) | |||
| Hidden Sheets | Excel Worksheet Functions | |||
| Unhide hidden sheets | Excel Discussion (Misc queries) | |||
| Hidden Data to show on the Chart | Charts and Charting in Excel | |||
| my tabs are hidden and can't make them show | Excel Discussion (Misc queries) | |||
Linear Mode
