how to unhide several sheets at one time ?

P

Peo Sjoblom

You can't using anything built in, only was is to use VBA code


--


Regards,


Peo Sjoblom
 
J

Joerg Mochikun

Maybe with a short macro:

Sub UnhideSheets()
If ActiveWorkbook.ProtectStructure = True Then
MsgBox "Unable to unhide sheets. Workbook is protected",
vbExclamation
Else
For Each ws In Sheets
ws.Visible = True
Next
End If
End Sub
 
Top