#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 10
Default 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   Report Post  
Posted to microsoft.public.excel.setup
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel make the tabs a the bottom stack vertically. Brian Excel Discussion (Misc queries) 0 March 23rd 06 09:49 PM
Sheet Tabs Aaron (ireland) Excel Discussion (Misc queries) 5 July 19th 05 01:39 PM
Tabs accross of bottom of sheet are not showing robert Excel Discussion (Misc queries) 3 April 22nd 05 09:29 PM
Hidding Tabs Aviator Excel Discussion (Misc queries) 1 December 15th 04 05:55 PM
Sheet tabs disappear sometimes in Internet Explorer Jan Nordgreen Excel Discussion (Misc queries) 0 December 6th 04 02:34 AM


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"