Excel - Hidden worksheets

Dear Michael

Thank you for attending Excel Advanced course.

Unfortunately there is not certain command to do what you are seeking but however with VBA you should be able to get the results.

Please follow these steps:

Step 1: Choose Tools> Macro > Visual Basic Editor... (Or ALT F11 to get the Visual basic Editor Window on the screen.

Step 2: Choose Insert > Module.

Step 3: In the module window copy and paste this:

Sub UnHideAll()

'unhide all sheets in a workbook

Dim sht As Worksheet

For Each sht In ActiveWorkbook.Sheets

sht.Visible = xlSheetVisible

Next

End Sub

Step 4: Click the [b Save Button [/b] and close the Visual Basic Editor Window.

Step 5: Choose [b] Tools> Macro> Macros