ExcelBanter - Hidden Worsheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hidden Worsheets (https://www.excelbanter.com/excel-programming/291454-hidden-worsheets.html)

Shamsul Islam

Hidden Worsheets

Hi,

What code can be used to unhide all hidden worksheets?

Thanks

Sham

Frank Kabel

Hidden Worsheets

Hi
try the following
Sub unhide_all()
Dim wkSht As Worksheet
For Each wkSht In Activeworkbook.worksheets
wkSht.visible = true
Next wkSht
End Sub

--
Regards
Frank Kabel
Frankfurt, Germany

Shamsul Islam wrote:
Hi,

What code can be used to unhide all hidden worksheets?

Thanks

Sham

All times are GMT +1. The time now is 07:00 PM.