Installing a button with VBA
 

I have written a macro that I want to make into an Add-in using Exce
2000. What I am trying to do is when I select my Add-in, I would lik
it to install a button on the toolbar that is assigned to my Add-in.
have seen this done but not sure how. Any suggestions

--
Message posted from http://www.ExcelForum.com

Installing a button with VBA
 

use the workbook_open event of the addin.

Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

Here is another article or two you might find useful:
http://msdn.microsoft.com/library/ba...n_addins97.htm
http://msdn.microsoft.com/library/of...exceladdin.htm
http://www.microsoft.com/exceldev/tips/addins.htm
These are about distributing applications

for explanation of events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"crwill " wrote in message
...
I have written a macro that I want to make into an Add-in using Excel
2000. What I am trying to do is when I select my Add-in, I would like
it to install a button on the toolbar that is assigned to my Add-in. I
have seen this done but not sure how. Any suggestions?


---
Message posted from http://www.ExcelForum.com/