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 |
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. |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com