how to unhide several sheets at one time ?
 

how to unhide several sheets at one time ?
 

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


--


Regards,


Peo Sjoblom



"Peggy" wrote in message
...

how to unhide several sheets at one time ?
 

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

"Peo Sjoblom" wrote in message
...
You can't using anything built in, only was is to use VBA code


--


Regards,


Peo Sjoblom



"Peggy" wrote in message
...