How to display all hidden sheets?

[maheshmaxi]

Hi,

I have more than twenty sheets in my excel file which are hidden, is there any shortcut to display all sheets, without clicking everytime format -> sheet -> unhide?

 

[Richard Schollar]

Open up the VBE (Alt+F11), open up the Immediate Window (Ctrl+G) and type in the following and press Enter:

For Each ws In Worksheets:ws.Visible = xlSheetVisible:Next

 

[maheshmaxi]

Thanks Mr.Richard. It's working fine.