Not able to unhide sheet in Excel 2002

  • Thread starter Thread starter K H Puah
  • Start date Start date
K

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
 
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
 
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
 
Back
Top