Unhide Multiple Sheets
 

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

Unhide Multiple Sheets
 

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

Unhide Multiple Sheets
 

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

Unhide Multiple Sheets
 

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

Unhide Multiple Sheets
 

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

Unhide Multiple Sheets
 

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