Not able to unhide sheet in Excel 2002

[K H Puah]

I used Format>Hide>Worksheet in Excel 2002 file. Now I am using Excel 2007
but when I tried to unhie the worksheet, the Unhide option is disabled.
Please help.

K H Puah

 

[KC]

goto vba editor (ALT+F11)

paste the below code and
press F5 OR run through macro



Sub UnHideHiddenSheets()
For Each Sht In ACtiveworkbook.Worksheets
Sht.Visible = xlSheetVisible
Next Sht
End Sub

-kc
*Click YES if this works

 

[Gord Dibben]

Have you protected the workbook under Review>Protect Workbook?


Gord Dibben MS Excel MVP

On Thu, 21 Jan 2010 16:55:01 -0800, K H Puah <K H