jase71ds
Board Regular
- Joined
- Oct 23, 2006
- Messages
- 137
- Office Version
- 365
- Platform
- Windows
Hi all.
I'll say in advance that I always appreciate your time and help. Today is no different, so thanks!
I have a templated macro file named: "VTA Report.xltm".
The user needs to right-mouse-click and select "Open" from the contextual menu.
So...
As soon as they try to run the macros (assigned to a button) I'd like for Excel to check and see if the name of the active workbook is "VTA Reports.xltm". If they opened it by merely double-clicking the name will be "VTA Reports1.xlxm"
So, Active Workbook should = "VTA Reports.xltm"
If not, then Msg Box("yada, yada")
Then quit the file without saving: Application.Quit
Thanks for any help.
Jase.
I'll say in advance that I always appreciate your time and help. Today is no different, so thanks!
I have a templated macro file named: "VTA Report.xltm".
The user needs to right-mouse-click and select "Open" from the contextual menu.
So...
As soon as they try to run the macros (assigned to a button) I'd like for Excel to check and see if the name of the active workbook is "VTA Reports.xltm". If they opened it by merely double-clicking the name will be "VTA Reports1.xlxm"
So, Active Workbook should = "VTA Reports.xltm"
If not, then Msg Box("yada, yada")
Then quit the file without saving: Application.Quit
Thanks for any help.
Jase.