MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Unhiding Sheets

Posted by Carolyn on September 25, 2001 6:12 AM

I have several workbooks in which I keep multiple sheets hidden. Is there an easier way to unhide the sheets rather than the one-by-one method of format-sheet-unhide? Thank You for your help

Posted by Daniel on September 25, 2001 6:59 AM

You could use a very simple bit of code:-

Sub UnhideAllSheets()
For Each s In ActiveWorkbook.Sheets
s.Visible = xlSheetVisible
End Sub


Posted by Mike on September 25, 2001 7:02 AM

...there may be a more scientific way but I simply record a macro the first time that I unhide them (tools-macro-record new macro)and then use this subsequent times - connected to a button on a worksheet this is a one-click operation to unhide all required sheets......if it is for client use you can record the macro in a different workbook so that only you have access to it...