Excel Macro-Enabled Template opens template file when running macro

[shilohb12]

I finally got my first VBA Excel macro up and running, but am having issues when using the *.xltm file I created.When I open Excel and select File>New>My templates and select my created template (called Resource Report Workbook), everything works perfectly...I get a new workbook opened named "Resource Report Workbook1"). When I run the macro for this workbook, Excel runs the macro on "Resource Report Workbook1", but also opens the original template workbook.I am writing this template with macros for someone else, so I need to macros to save with the template for when I send him the finished product (this is why they aren't in my PERSONAL.xls file).How can I prevent Excel from opening the template file when running the macro? I'm using Excel 2010. Thanks in advance!!​