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
|