View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default needing xla assistance

....John,
If you are going to distribute the add-in to others then you will need
to create the menu item(s) when the add-in is installed and delete then
when the add-in is uninstalled.
This is normally accomplished in the ThisWorkbook module using the
Private Sub Workbook_AddinInstall() and Private Sub Workbook_AddinUninstall()
events. You will have to write menu code for each of the subs.

If you are using the add-in only for yourself, then you can right-click a menu bar
and choose "Customize". Then right-click the custom menu item and
choose "Assign Macro". Enter the add-in name/ macro name in a format
similar to the following... 'MyAddinName.xla'!MyMacroName
(note the single quote marks and the exclamation point)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"JohnE"
wrote in message
I have an xla addin and want to have it run from a custom menu button. I
have the xla ready to go but am uncertain of how to get it to work using the
button. There are other xla addins that run from other buttons done by prior
person but no documentation on what they did and I see no other coding other
then the vba code for the addin. I thought it was a macro button but that is
not connecting. Can someone help out on this process?
Thanks.
.... John