| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forcing users to enter value based on criteria | Excel Discussion (Misc queries) | |||
| Forcing users to update spreadsheets | Excel Discussion (Misc queries) | |||
| Forcing users to complete a form | Excel Discussion (Misc queries) | |||
| Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions | |||
| Forcing users to enable macros | Excel Programming | |||
Hybrid Mode
