ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Forcing users (https://www.excelbanter.com/excel-programming/294094-forcing-users.html)

M atthew J. Couture

Forcing users
 
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?



Tom Ogilvy

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?






All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com