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

If the user does file=New and selects you template as the model, then yes.
If the user opens your template with file=Open, then there is no built in
support for it. You could perhaps code something in the workbook_open
event. However, using the first method would be preferable.

--
Regards,
Tom Ogilvy

"M atthew J. Couture" wrote in message
...
I would like to force a user to create a copy os a template workbook when
opening the original, preventing overwriting of the original. Doing so it
would need to have default location and also chage file extension to .xls
not .xlt, is this possible?