Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
CyberTaz
 
Posts: n/a
Default Excel: Enable UnHiding of multiple sheets at once

When you have multiple sheets hidden in workbook and want to unhide more tha
one, you must go back thru the dialog box to unhide each. Why not write this
one to be like most others so you can shift-click/ctrl-click the sheetnames
you want to unhide while you're ther ONCE and unhide them all at one time?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Cyber

http://register.microsoft.com/mswish/suggestion.asp

While waiting for MS to make the changes in the next version you could use a
macro.

Sub Show_Sheets()
Dim i As Integer
For i = 1 To ActiveWorkbook.Worksheets.Count
ActiveWorkbook.Worksheets(i).Visible = True
Next i
End Sub


Gord Dibben Excel MVP

On Thu, 13 Jan 2005 11:33:02 -0800, "CyberTaz"
wrote:

When you have multiple sheets hidden in workbook and want to unhide more tha
one, you must go back thru the dialog box to unhide each. Why not write this
one to be like most others so you can shift-click/ctrl-click the sheetnames
you want to unhide while you're ther ONCE and unhide them all at one time?


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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
editing multiple sheets at once blamires Excel Discussion (Misc queries) 1 January 5th 05 09:51 PM
Multiple sheets selected twa14 Excel Discussion (Misc queries) 2 December 21st 04 12:15 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 08:43 AM
How do I plot data in Excel that is captured on separate sheets; . krwegner Excel Discussion (Misc queries) 0 November 30th 04 06:43 PM


All times are GMT +1. The time now is 11:58 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"