Inserting Macros into Custom Ribbon

[Skinny1434]

Heres one that has really been bugging me as of late. I created a custom ribbon (Excel 2010) that has a few different macros that I created. These are very simple macros. I want to be able to use these macros for any workbook, but when I click the button on the ribbon it runs the macro and opens the original excel workbook that the macro was created in. If I run the macro through VBA it does not do this, only when I click the button on the custom ribbon. Does anyone know why this happens or how I can get this to stop? Thank you!!

 

[Trevor G]

I would suggest placing the macros in the Personal Workbook rather than a workbook. As when you select to run a macro it will refer to the original workbook name.

 

[Skinny1434]

this is an option, the only thing about that is the annoying message you get when opening a new workbook "locked for editing" is there any way around this?