View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Forcing a FileSaveAs

Of course if you edit it as an xla, you would need to disable events or hold
down the shift key when you open it.

--
Regards,
Tom Ogilvy

John Petty wrote in message
...
Thanks Tom.
-----Original Message-----
As soon as it is opened using File=New, it is an xls, so

you could
certainly do it in the workbook_Open event.

--
Regards,
Tom Ogilvy

John Petty wrote in message
...
Is there a way that I can force the user to save a
template to an XLS upon opening the template (i.e. Sub
open_Workbook)



.