How do I add command buttom?

[rgarber50]

I've written a macro that I want to fire using a command button. I wrot
a macro that adds the button - and one that deletes it just fine
However I am having problems automating the adding and the deleting o
the button on the standard toolbar - I only want it available for
particular workbook.

I thought I should be using an event procedure. So I've trie
different combinations of:
Open
Before close
Workbook activate
deactivate.

In the event procedures I am either calling a procedure in a standar
module that adds the button, or a procedure that deletes the button o
the standard toolbar.

Sometimes it runs fine - other times it errors out - sometimes I end u
with multiple buttons. I want to be able to be able to activate anothe
workbook and have the btn deleted = when back add it again. I also wan
to be able to close the workbook and have the button deleted.

Thanks for any suggestions.
Richar

 

[Anne Troy]

It belongs in the Workbook_Open event.
You need to delete it on Before_Close.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com