How to add button/toolbar to one workbook only when it opens

Could someone help me by suggesting a code that would initialize and delete a button that runs a certain macro. Right now, I have a button that is on the toolbar and stays there regardless of what excel file I use. It's unecessary and annoying.
I know that the sub workbook_open and sub workbook_beforeclose have to be used but I'm kinda clueless after that.

Hello EK1,

Here are two macro you can use. One adds a button to the Excel menu bar called "Run Macro". This has ALT+R as the hot key. The second macro removes the button. Each of these will need to be called from the appropriate Workbook event. The button is temporary and should be removed when the workbook closes, but this is Windows. You will need to make some changes to the macro. They are marked with comments in the code. Copy this code to a VBA module.

Add and Delete Menu Button Macros

Please Login or Register  to view this content.

Workbook Event Module Code
Add this code to the ThisWorkbook module.

Please Login or Register  to view this content.

This is not possible with VBA and Ribbon. You must use CustomUI.xml part for this.