Hello,

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


Sub showMe()
UserForm1.Show
End Sub

Regards
Runner7

--
Runner7
-----------------------------------------------------------------------
Runner77's Profile: http://www.excelforum.com/member.php...fo&userid=3038
View this thread: http://www.excelforum.com/showthread.php?threadid=50157

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

--


Gary


"Runner77" wrote in
message ...

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
...
Worksheets("frontpage").Visible = False
Worksheets("sheet1").Visible = True

--


Gary


"Runner77" wrote
in
message ...

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