Unhiding work sheets

[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.

 

[Kevin Stecyk]

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

 

[Marcy]

Try a great free utility www.asap-utilities.com
Or, if you wish to spend a little money...try the
Spreadsheet Assistant at www.add-ins.com
I've found both to be quite helpful.

HTH,
Marcy


Original Message-----

 

[Kevin Stecyk]

Marcy,

Thank you!

Regards,
Kevin

Try a great free utility www.asap-utilities.com
Or, if you wish to spend a little money...try the
Spreadsheet Assistant at www.add-ins.com
I've found both to be quite helpful.

HTH,
Marcy


Original Message-----