I know you can hide multiple sheets by grouping the sheets and then using the
sheet "hide" ... but is there a way to unhide multiple sheets? If you use the
same logic as hiding multiple sheets - EXCEL wants you to select which sheet
to unhide. Unless I am doing something wrong - it will not permit you to
select multiple sheets to unhide. I am using Excel 2003

Use a macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bev" wrote in message
...
I know you can hide multiple sheets by grouping the sheets and then using
the
sheet "hide" ... but is there a way to unhide multiple sheets? If you use
the
same logic as hiding multiple sheets - EXCEL wants you to select which
sheet
to unhide. Unless I am doing something wrong - it will not permit you to
select multiple sheets to unhide. I am using Excel 2003

In 2003 it will not allow you to select more than one sheet from the list
while unhiding.

If this post helps click Yes
---------------
Jacob Skaria


"Bev" wrote:

I know you can hide multiple sheets by grouping the sheets and then using the
sheet "hide" ... but is there a way to unhide multiple sheets? If you use the
same logic as hiding multiple sheets - EXCEL wants you to select which sheet
to unhide. Unless I am doing something wrong - it will not permit you to
select multiple sheets to unhide. I am using Excel 2003

Bev,

Right click ant sheet tab, view code and paste this code in. If you run it
all hidden sheets become unhidden

Sub Sonic()
For x = 1 To Worksheets.Count
Sheets(x).Visible = True
Next
End Sub

Mike

"Bev" wrote:

I know you can hide multiple sheets by grouping the sheets and then using the
sheet "hide" ... but is there a way to unhide multiple sheets? If you use the
same logic as hiding multiple sheets - EXCEL wants you to select which sheet
to unhide. Unless I am doing something wrong - it will not permit you to
select multiple sheets to unhide. I am using Excel 2003

Thank you - works like a charm ....

"Mike H" wrote:

Bev,

Right click ant sheet tab, view code and paste this code in. If you run it
all hidden sheets become unhidden

Sub Sonic()
For x = 1 To Worksheets.Count
Sheets(x).Visible = True
Next
End Sub

Mike

"Bev" wrote:

I know you can hide multiple sheets by grouping the sheets and then using the
sheet "hide" ... but is there a way to unhide multiple sheets? If you use the
same logic as hiding multiple sheets - EXCEL wants you to select which sheet
to unhide. Unless I am doing something wrong - it will not permit you to
select multiple sheets to unhide. I am using Excel 2003

Yiur welcome

"Bev" wrote:

Thank you - works like a charm ....

"Mike H" wrote:

Bev,

Right click ant sheet tab, view code and paste this code in. If you run it
all hidden sheets become unhidden

Sub Sonic()
For x = 1 To Worksheets.Count
Sheets(x).Visible = True
Next
End Sub

Mike

"Bev" wrote:

I know you can hide multiple sheets by grouping the sheets and then using the
sheet "hide" ... but is there a way to unhide multiple sheets? If you use the
same logic as hiding multiple sheets - EXCEL wants you to select which sheet
to unhide. Unless I am doing something wrong - it will not permit you to
select multiple sheets to unhide. I am using Excel 2003