View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tpeter tpeter is offline
external usenet poster
 
Posts: 74
Default Don't Show Msg Box if file ext is .xls

I have a message box that opens when my spreadsheet is opened asking if it is
a new file. If they click yes, a user form comes up with selections. The file
is in Excel 2003 and is a template(the folder it is located in has special
privilages which allows you to open it without it being opened as a workbook,
so it is still a template and can be saved as a template without doing save
as template). I would like the message box and form to not appear and go
directly to sheet1 if the file has already been set up and saved as a .xls
file. Thank you for your assistance.

Tim Peter