Assign Macro to a Button on Open of Excel File

[theglitch]

Hi Experts,

I have an issue that I am not sure how to solve. I need to assign a macro to a Button in my Excel file, BUT, I need to assign when the file opens. I have an issue when the file is closed the button stays on the sheet but the macro gets stripped from the button. So, when the file opens I would like for the macro to get reassigned to the button. Below is what I have tried so far, but I am getting a run time error. Any thoughts or a new method would be greatly appreciated.

Thanks

Please Login or Register  to view this content.

[Logit]

.
????

How is macro "stripped" from the button when the workbook closes ?

[theglitch]

Hi Logit,

Thanks for the reply. If it helps, you can think of it as the button not appearing when the file is opened. The Macro was there when the file was created and saved but when I or someone else goes to open it the button is no longer on the tab. To answer your question the Excel file is going through another program that is dropping the Button with the macro when re-opened.

Thanks

[BellyGas]

"The Excel file is going through another program..."

Can you elaborate on that?

[theglitch]

Thanks to everyone for the concern as to why the macro gets removed from the button but I was able to work out a solution to get the button added and the macro re-attached when the file opens and to check to see if the button is already there and not add it a second time. Thanks again everyone.