Show Form and Hide Worksheet on Load
Something along the lines of
Private Sub Workbook_Open()
Application.Visible = False
Userform1.Show
Application.Visible = True
End Sub
The application has to open, so you can't totally hide it. It will flash.
--
regards,
Tom Ogilvy
"Chris George" wrote in message
...
Sheets([Insert Sheet name here]).Visible = False
Hope this helps, maybe putting workbook in there might work as well.
Cheers mate but unfortunatly it does not like the syntax, maybe I should
reiterate what im trying to do I have written a vba within excel and when
loading the *.xls I only want to see the form, nothing else not even the
excel application if possible..
Thanks
Chris
|