XLA Right Click addin

[mpeplow]

Where would I put the code that goes into 'This Workbook' before
creating a XLA file so that it will be reconised when the addin loads?
Excel does not seem to see the code in the 'This Workbook' part of the
addin. The part that creates the options in the menu.

Can anyone help?


In case you need it. Im using the code below.
http://www.ozgrid.com/VBA/right-click.htm

 

[Die_Another_Day]

How about:
Private Sub Workbook_AddinInstall()

End Sub

Die_Another_Day

 

[Bob Phillips]

It should do. I use it regularly, loading menus etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[mpeplow]

I'm not familiar with that option. Can someone explain how to use or
point me to a link. I can only find C code related to this option.

Thanks All

 

[Bob Phillips]

What option?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[mpeplow]

Workbook_AddinInstal