Macro in Template opens new workbook or macro file not found error

I am using excel from office 365/2016. I recorded a macro in a template. Template is called from another application(MSPROJECT) and when opening, it opens as an excel workbook with a new name. When the macro is run from the new workbook, it opens the original template and modifies that template rather than the new workbook. If I update and rename the template and delete the old template, the macro does not work at all and says it cannot find the old template. How do I get the macro to be part of the workbook from which it is run rather than referencing the template where it was created? Note that the templates are shared with different people after updating rather than having a central location, so I am trying not to have the macros associated with files on my machine.

Thanks for the reply DFLAK. Good information and it helped me troubleshoot the real problem. It was not the macro code. It is the fact that I added the macro to the Ribbon and Quick access toolbar. If I use the macro call from the ribbon, it opens the original workbook and runs the macro from the original file. If I just run the macro from the developer tabs it works fine from the open workbook. So the new question is whether you can set the macro call from the Ribbon and quick access toolbars to where it just looks at the current workbook.