View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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