Unhidding Tabs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mdavison - 23 Aug 2006 20:50 GMT

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

>Format>Tabs>Unhide 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.

Reply to this Message

Max - 25 Aug 2006 02:29 GMT

> .. 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

.."

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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
[quoted text clipped - 3 lines]
> can do for columns and rows.
> Thank you.

Reply to this Message