Autorun Add-in

T

Todd Heiks

How do i make my addin run when it is added to excel?
I want the user to browse to my addin and then have the addin build the
toolbar for itself.

Regards,
Todd
 
C

Chip Pearson

In the XLA's ThisWorkbook code module, put the code to build the menu:

Private Sub Workbook_Open()
' your code here
End Sub

Then, use BeforeClose to delete the menu:

Private Sub Workbook_BeforeClose(ByRef Cancel As Boolean)
' your code here
End Sub

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
G

Gord Dibben

Your add-in needs some Workbook_Open event code in Thisworkbook module or
Auto_Open code in a general module.

The code will build the Toolbar.

Don't forget to delete the Toolbar when the add-in closes.

See Debra Dalgleish's site for sample by Dave Peterson.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP
 
T

Todd Heiks

I'll try it. Thanks.


Chip Pearson said:
In the XLA's ThisWorkbook code module, put the code to build the menu:

Private Sub Workbook_Open()
' your code here
End Sub

Then, use BeforeClose to delete the menu:

Private Sub Workbook_BeforeClose(ByRef Cancel As Boolean)
' your code here
End Sub

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



How do i make my addin run when it is added to excel?
I want the user to browse to my addin and then have the addin build the
toolbar for itself.

Regards,
Todd
Click to expand...
Click to expand...
 
Top