Hide/Unhide Sheets

Hello,

I would like to hide Sheet called FrontPage and unhide SHeet Called SHeet1 once i have run the following macro.


Sub showMe()
UserForm1.Show
End Sub

Regards
Runner77

Worksheets("frontpage").Visible = False
Worksheets("sheet1").Visible = True

--


Gary


"Runner77" <Runner77.21prim_1137391802.1752@excelforum-nospam.com> wrote in
message news:Runner77.21prim_1137391802.1752@excelforum-nospam.com...
>
> Hello,
>
> I would like to hide Sheet called FrontPage and unhide SHeet Called
> SHeet1 once i have run the following macro.
>
>
> Sub showMe()
> UserForm1.Show
> End Sub
>
> Regards
> Runner77
>
>
> --
> Runner77
> ------------------------------------------------------------------------
> Runner77's Profile:
> http://www.excelforum.com/member.php...o&userid=30388
> View this thread: http://www.excelforum.com/showthread...hreadid=501576
>

Maybe best to do it the other way around in case frontpage is the only
visible sheet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:eIxJkUmGGHA.216@TK2MSFTNGP15.phx.gbl...
> Worksheets("frontpage").Visible = False
> Worksheets("sheet1").Visible = True
>
> --
>
>
> Gary
>
>
> "Runner77" <Runner77.21prim_1137391802.1752@excelforum-nospam.com> wrote
in
> message news:Runner77.21prim_1137391802.1752@excelforum-nospam.com...
> >
> > Hello,
> >
> > I would like to hide Sheet called FrontPage and unhide SHeet Called
> > SHeet1 once i have run the following macro.
> >
> >
> > Sub showMe()
> > UserForm1.Show
> > End Sub
> >
> > Regards
> > Runner77
> >
> >
> > --
> > Runner77
> > ------------------------------------------------------------------------
> > Runner77's Profile:
> > http://www.excelforum.com/member.php...o&userid=30388
> > View this thread:
http://www.excelforum.com/showthread...hreadid=501576
> >
>
>