View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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