Unhide multiple worksheets in workbook


M

Maureen D.

Hi...I have Excel 2003. Is there a way to unhide multiple worksheets in a
workbook vs. unhiding one at a time?
 
Ad

Advertisements

Ad

Advertisements

G

Gord Dibben

Sub unhide()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Visible = xlHidden Then ws.Visible = xlSheetVisible
Next ws
End Sub


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unhide Multiple Sheets 2
lost a column,A, In a worhsheet 1
Unhide a column 2
Unhide a row 1
Hide and unhide...what the heck!!?? 6
Unhide macro worksheet 2
Data Validation List Macro 18
Unhiding multiple sheets 2

Top