View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chris George Chris George is offline
external usenet poster
 
Posts: 3
Default Show Form and Hide Worksheet on Load


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