Prev: Row labels displayed as column labels
Next: Separating data in a column
From: Maureen D. on 27 Jan 2010 12:13
Hi...I have Excel 2003. Is there a way to unhide multiple worksheets in a
workbook vs. unhiding one at a time?
From: Don Guillett on 27 Jan 2010 12:40
a looping macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Maureen D." <MaureenD(a)discussions.microsoft.com> wrote in message
news:FFCDB6D9-4AB3-44DF-A269-2561289038FC(a)microsoft.com...
> Hi...I have Excel 2003. Is there a way to unhide multiple worksheets in a
> workbook vs. unhiding one at a time?

From: Gord Dibben on 27 Jan 2010 14:50
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.
<MaureenD(a)discussions.microsoft.com> wrote:

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

 | 
Pages: 1
Prev: Row labels displayed as column labels
Next: Separating data in a column