.. hide tabs en mass

To unhide tabs en mass, try this sub
(Roger Govier gave it to me 5 years ago)

".. The following will carry out the unhide for all sheets within the
workbook

Sub ShowSheets()
Dim s As Worksheet
For Each s In ActiveWorkbook.Worksheets
s.Visible = True
Next
End Sub

..."
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mdavison" wrote:
Currently in 2003, we can hide tabs en mass by grouping. But when we want to
get a batch back - we have to unhide them individually, the
FormatTabsUnhide dialog does not allow for multiple tab selection with
Ctrl or Shift. This is incredibly tedious is large workbooks. I suggestion
this be modified so multiple tabs can be unhidden at one time. Just like we
can do for columns and rows.
Thank you.