Re: Unhide more than one worksheet at a time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: DBavirsha (DBavirsha_at_discussions.microsoft.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 15:35:01 -0800

Chip,

Thanks for the reply. I will try all the replies and use one of them.

Dave
  =@===----¬----¬----¬.¸¸.·´¯`·.¸¸.·´¯`·.¸.·<º))))><

"Chip Pearson" wrote:

> Dave,
>
> Try the following code:
>
> Sub AAA()
> Dim WS As Work***
> For Each WS In ActiveWorkbook.Worksheets
> WS.Visible = True
> Next WS
> End Sub
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
>
> "DBavirsha" <DBavirsha@discussions.microsoft.com> wrote in
> message
> news:16BAD985-5983-4BFA-9788-729622C19ED6@microsoft.com...
> >I have a worksheet that contains 50 hidden worksheets. Is there
> >a method or
> > macro that somebody knows of where I can unhide more than one
> > workseet at a
> > time?
> >
> > Thanks, Dave
> > =@===----¬----¬----¬.¸¸.·´¯`·.¸¸.·´¯`·.¸.·<º))))><
>
>
>

Quantcast