| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not able to unhide sheet in Excel 2002
I used FormatHideWorksheet 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not able to unhide sheet in Excel 2002
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 "K H Puah" wrote: I used FormatHideWorksheet 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not able to unhide sheet in Excel 2002
Have you protected the workbook under ReviewProtect Workbook?
Gord Dibben MS Excel MVP On Thu, 21 Jan 2010 16:55:01 -0800, K H Puah <K H wrote: I used FormatHideWorksheet 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide / Unhide Sheet Tabs Excel 2007 | Excel Discussion (Misc queries) | |||
| How to hide/unhide sheet Tabs in Excel 2007? | Excel Worksheet Functions | |||
| How can I find/unhide hidden excel sheet tabs on a worksheet? | Excel Worksheet Functions | |||
| how do i unhide a worksheet in excel 2003? unhide tab don't work | Excel Discussion (Misc queries) | |||
| Excel 2002 Unhide Columns Shortcut?? | Excel Discussion (Misc queries) | |||
Linear Mode
