Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to unhide multiple sheets in one go
Hi,
I have multiple sheets in a workbook hidden and at times I need to unhide them all in one go. However the problem with the unhide feature is that it only allows you to unhide one sheet at a time. I have over 22 hidden sheets so this is a real problem for me. I've tried doing some VBA but got stuck. Could'nt get it to work. Anyone done this before or could give me hints Thanks in advance Sandra |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to unhide multiple sheets in one go
Grd, here is one way,
Sub unhide_all_sheets() Dim ws As Worksheet For Each ws In Worksheets ws.Visible = True Next ws End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Grd" wrote in message ... Hi, I have multiple sheets in a workbook hidden and at times I need to unhide them all in one go. However the problem with the unhide feature is that it only allows you to unhide one sheet at a time. I have over 22 hidden sheets so this is a real problem for me. I've tried doing some VBA but got stuck. Could'nt get it to work. Anyone done this before or could give me hints Thanks in advance Sandra |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to unhide multiple sheets in one go
Great Paul That does the trick "Paul B" wrote: Grd, here is one way, Sub unhide_all_sheets() Dim ws As Worksheet For Each ws In Worksheets ws.Visible = True Next ws End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Grd" wrote in message ... Hi, I have multiple sheets in a workbook hidden and at times I need to unhide them all in one go. However the problem with the unhide feature is that it only allows you to unhide one sheet at a time. I have over 22 hidden sheets so this is a real problem for me. I've tried doing some VBA but got stuck. Could'nt get it to work. Anyone done this before or could give me hints Thanks in advance Sandra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unhide Multiple Sheets | Excel Discussion (Misc queries) | |||
Unhide multiple sheets | Excel Discussion (Misc queries) | |||
Unhide multiple sheets all at once | Excel Discussion (Misc queries) | |||
Can I unhide multiple sheets at once? | Excel Discussion (Misc queries) | |||
How do I unhide multiple sheets? | Excel Worksheet Functions |