Excel Macro calling from Original Code Location Spreadsheet

I have a "Builder" Workbook that is bringing in external sheets from other workbooks. The end result is a workbook compiled of quotes and other documents that salesman require for a system project.
Fundamentally, All the code works. After a "Sheet" has been brought into the "Builder" when a button is used in the new workbook the original workbook the sheet was copied from is opening to run the code.

I have tried removing code from module and putting it under Sheet Objects and Re-Assigning Macros to buttons but this does not solve my problem.


My only code experience is 1 C++ class in high school.

Hello WFIR;
One thing that comes to mind is that there may be a reference to the other workbook.
Goto your VBEditor and check for a reference in the project explorer.

If this is the issue you can goto "Tools...References" and unclick that reference ... if not needed.

See example of reference in screen shot .




scrShot012.gif


if this has helped please click "Add reputation"

I don't have that reference activated unfortunately.
Once I bring a sheet to the "Builder" if i look at the macro assigned to the button it references the original workbook it came from.
I believe VBA is just not able to do what i was trying to do.

To temporarily solve my problem I have set up a workbook that I am using strictly for my routines. All buttons I use will come from that workbook and every routine will end with closing said workbook.
This will also make it easier to update the routines without having to edit each of the hundreds of Base Machine quote files down the road.

Hello WFIR:
You may want to look into having a workbook as an "AddIn" . Or adding your needed macros to your Personal.xlb.
Either of these options will allow you access to macros that are not in the local book but you're not seeing additional workbooks being opened.
Just and idea