When you have many hidden sheets and want to unhide several of them, it's
time consuming to click unhide several times just to unhide multiple ones.
Just adding the option to use the shift key to select multiple sheets to
unhide would be very helpful.

----------------
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...lic.excel.misc

Using key strokes, I can unhide 10 sheets in less than 8 seconds, so, not
sure if it is a feature that is 'pressing' IMHO.
--
John C


"Jason" wrote:

When you have many hidden sheets and want to unhide several of them, it's
time consuming to click unhide several times just to unhide multiple ones.
Just adding the option to use the shift key to select multiple sheets to
unhide would be very helpful.

----------------
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...lic.excel.misc

I agree with you.

Maybe you could create a macro and store it in your personal.xls that displays a
userform that allows you to unhide more than one sheet at a time.

If you want to learn about userforms:

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp



Jason wrote:

When you have many hidden sheets and want to unhide several of them, it's
time consuming to click unhide several times just to unhide multiple ones.
Just adding the option to use the shift key to select multiple sheets to
unhide would be very helpful.

----------------
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...lic.excel.misc

--

Dave Peterson

Hi. Here's a simple macro that will unhide sheets between two selected visible sheets.

Sub UnhideSheets()
'// = = = = = = = = = = = = = = = = = = =
'// Select 2 adjacent sheets.
'// Macro will unhide sheets between selected sheets.
'// = = = = = = = = = = = = = = = = = = =
Dim a As Long
Dim b As Long
Dim J As Long

With ActiveWindow.SelectedSheets
a = .Item(1).Index + 1
b = .Item(2).Index - 1
For J = a To b
Sheets(J).Visible = True
Next J
End With
End Sub

--
HTH :)
Dana DeLouis


"Jason" wrote in message ...

When you have many hidden sheets and want to unhide several of them, it's
time consuming to click unhide several times just to unhide multiple ones.
Just adding the option to use the shift key to select multiple sheets to
unhide would be very helpful.

----------------
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...lic.excel.misc

John C,

I have more than 10 sheets and what keystrokes are you using to be able to
do it in 8 seconds?

Dave and Dana, thanks for the suggustion, I already have a macro that does
it. I just think it should be a feature in Excel rather than something we
have to create VB programming for.

It really can't be that hard to allow me to use the ctrl or shift key in the
unhide sheets box.

"Dana DeLouis" wrote:

Hi. Here's a simple macro that will unhide sheets between two selected
visible sheets.

Sub UnhideSheets()
'// = = = = = = = = = = = = = = = = = = =
'// Select 2 adjacent sheets.
'// Macro will unhide sheets between selected sheets.
'// = = = = = = = = = = = = = = = = = = =
Dim a As Long
Dim b As Long
Dim J As Long

With ActiveWindow.SelectedSheets
a = .Item(1).Index + 1
b = .Item(2).Index - 1
For J = a To b
Sheets(J).Visible = True
Next J
End With
End Sub

--
HTH :)
Dana DeLouis


"Jason" wrote in message
...
When you have many hidden sheets and want to unhide several of them,
it's
time consuming to click unhide several times just to unhide multiple
ones.
Just adding the option to use the shift key to select multiple sheets to
unhide would be very helpful.

----------------
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...?mid=0501a760-
17f5-4022-8f1f-6a6e8679a97c&dg=microsoft.public.excel.misc