Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Unhidding Tabs
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. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...ic.excel.setup |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Unhidding Tabs
.. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel make the tabs a the bottom stack vertically. | Excel Discussion (Misc queries) | |||
Sheet Tabs | Excel Discussion (Misc queries) | |||
Tabs accross of bottom of sheet are not showing | Excel Discussion (Misc queries) | |||
Hidding Tabs | Excel Discussion (Misc queries) | |||
Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) |