I am trying to accomplish something that I would suspect is a common type of problem, but I have been all over the internet and I'm having trouble finding it:
I have a master excel workbook with lots of macros, formulas, and data from many sources which I copy each week to do my planning. I "save as" and add the week and date to the title. The problem is, the command buttons which call the macros are linking to the original / template workbook, so to run them, it must be opened (or excel will automatically open the original when I press the button).
What I need to do is turn off the command button linking to the source / original workbook. I want each button to look in the new workbook at the same modules, run the same functions, etc, but never look in the original / template.
Some specifics:
RM Master.xlsm is the template file I always start with
in Week 1, I save as: RM Master CW1.xlsm
RM Master CW1 has a command button in it which runs sub Export_DS which is stored in module 1.
When I click the command to run Export_DS, the macro it is linking to is actually [RM Master]Export_DS, so it opens RM Master, then runs the macro. How do I make it run the macro in RM Master CW1.xlsm?
I realize I could do this with a personal macro workbook and store the macros in there, but I need this file / process to work for other users on other computers as well. I have a basic understanding of Macros, but I am pretty new to it. I'm open to suggestions on how to best accomplish this.
Thanks for your help!
Brad
I have a master excel workbook with lots of macros, formulas, and data from many sources which I copy each week to do my planning. I "save as" and add the week and date to the title. The problem is, the command buttons which call the macros are linking to the original / template workbook, so to run them, it must be opened (or excel will automatically open the original when I press the button).
What I need to do is turn off the command button linking to the source / original workbook. I want each button to look in the new workbook at the same modules, run the same functions, etc, but never look in the original / template.
Some specifics:
RM Master.xlsm is the template file I always start with
in Week 1, I save as: RM Master CW1.xlsm
RM Master CW1 has a command button in it which runs sub Export_DS which is stored in module 1.
When I click the command to run Export_DS, the macro it is linking to is actually [RM Master]Export_DS, so it opens RM Master, then runs the macro. How do I make it run the macro in RM Master CW1.xlsm?
I realize I could do this with a personal macro workbook and store the macros in there, but I need this file / process to work for other users on other computers as well. I have a basic understanding of Macros, but I am pretty new to it. I'm open to suggestions on how to best accomplish this.
Thanks for your help!
Brad
