Unhide multiple worksheets in workbook
 

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

Unhide multiple worksheets in workbook
 

a looping macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Maureen D." wrote in message
...
Hi...I have Excel 2003. Is there a way to unhide multiple worksheets in a
workbook vs. unhiding one at a time?

Unhide multiple worksheets in workbook
 

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

On Wed, 27 Jan 2010 09:13:01 -0800, Maureen D.
wrote:

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