Unhiding Multiple Excel Sheets

[Ian]

Does anyone know how to Unhide more than one worksheet at
a time?

Thanks

 

[Frank Kabel]

Hi
only possible with VBA. Try something
sub inhide_all
dim wks as workseehts
for eack wks in activeworkbook.worksheets
wks.visible=true
next
end sub

 

[Guest]

after correcting the mispelling of "eack" I still get a data mis-match error. Please advise. Thanks, Bob

 

[Don Guillett]

You might check the spelling of worksheets in the dim statement

 

[Guest]

Don, thanks...I also made that correction, however, it's still buggy. Any assistance would be appreciated as I don't know VB. Bob

 

[Gord Dibben]

bobs

You found "eack".

Try changing the spelling of "workseehts" also

"Dim wks as Worksheets"

Gord Dibben Excel MVP

 

[Gord Dibben]

bobs

One more correction..

Sub unhide_all()
Dim wks As Worksheet 'correction here, remove the "s"
For Each wks In ActiveWorkbook.Worksheets
wks.Visible = True
Next
End Sub

Gord