Forcing users

  • Thread starter Thread starter M atthew J. Couture
  • Start date Start date
M

M atthew J. Couture

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XLT vs XLS 8
Excel template and default save name 1
using xltm as template 2
getting new workbook name from opened template 1
Where can I save Excel templates .XLT files? 2
Track Changes using xlt file. 1
Run a macro if file is a template 7
Template behaving like .xls file 3

Back
Top