dougmarkham
Active Member
- Joined
- Jul 19, 2016
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
Hi Folks,
I've created a multi-macro excel model that I've saved as a *.xltm file i.e., so that the users cannot damage the original file.
As hoped, when opened the file becomes filename1 instead of filename.xltm.
I can account for this in my vba code by referring to the workbook as filename1...no worries.
However, the users have managed to thwart my code by making input errors, deciding to close the workbook and reopen it.
Now the file reopens as filename2 instead of filename.xltm, thus causing code that refers to the workbook to error.
My question is this: is there a setting I can change so that *xltm files always open as filename1, no matter how many times the file is opened during one windows session?
Is there a solution to this issue?
I've considered run a macro upon opening the file i.e., to change the workbook name to filename1; however, just wondered if there was a well known solution to this?
Kind regards,
Doug.
I've created a multi-macro excel model that I've saved as a *.xltm file i.e., so that the users cannot damage the original file.
As hoped, when opened the file becomes filename1 instead of filename.xltm.
I can account for this in my vba code by referring to the workbook as filename1...no worries.
However, the users have managed to thwart my code by making input errors, deciding to close the workbook and reopen it.
Now the file reopens as filename2 instead of filename.xltm, thus causing code that refers to the workbook to error.
My question is this: is there a setting I can change so that *xltm files always open as filename1, no matter how many times the file is opened during one windows session?
Is there a solution to this issue?
I've considered run a macro upon opening the file i.e., to change the workbook name to filename1; however, just wondered if there was a well known solution to this?
Kind regards,
Doug.