Unhiding work sheets

  • Thread starter Thread starter Chitra
  • Start date Start date
C

Chitra

Is there any way to unhide multiple worksheets at one time. Currently, I
can unhide a worksheet by clicking on Format, Sheet and Unhide and
then double clicking on the specific worksheet.
 
Chitra,

Run this small macro and you can unhide ~ALL~ your worksheets quickly. If
you want to pick and choose, then I suspect you need a utility program that
shows the sheets hidden and allows you to select multiple sheets to unhide.

Regards,
Kevin

Sub UnHideSheets()

Dim wkSheet As Worksheet

For Each wkSheet In Worksheets
wkSheet.Visible = True
Next

End Sub
 
Back
Top