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