Installing a button with VBA

C

crwill

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
 
T

Tom Ogilvy

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/backgrnd/html/msdn_addins97.htm
http://msdn.microsoft.com/library/officedev/odeopg/deovrcreatingexceladdin.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
 
Top