I greatly appriciate any help that can be provided. I'm learning as I go here and you can see I have "borrowed" this code. I have writen a few macros but have never tried to make a add-in. I should point out I'm trying to save the .xla to a network location so when and if changes are needed I will not have to change all the locations that this will be used on. If I'm going about this wrong feel free to laugh at me but please point me in the right direction. Thanks again for any and all help!

I have created an add-in by saving as an .xla. It adds a menu button that is linked to a macro. Everything works fine except when I exit out of Excel then later go back into Excel I get an error message saying Excel cannot open a workbook with the same name twice, it's trying to open the .xla again. Do I have to un-install the add-in everytime I exit to avoid this error, or is there a way to get around this? I have attached the code in the .xla below.

This is in the "ThisWorkbook" section
Please Login or Register  to view this content.
This is the code to add the button. It is located in a standard module within the .xla.
Please Login or Register  to view this content.