Assigning add-in function to custom button

R

Robert

Hi, I created a macro and assigned it to a custom button
on the tool bar and it worked fine. Only problem is it
loads the workbook that contains the macro in order to run
it (only once per session of course).
I then saved workbook containing the macro as an add-in
(.xla) and went into add-ins in tool menue and checked my
add-in.
How do I assign a function wthin this add-in to a custom
button?
I tried starting the add-in manager in the vba editor but
it comes up blank.

Any sugestions?
 
T

Tom Ogilvy

With the xla loaded.
tools=>customize
leave the visible,
right click on the button,
choose assign macro

MyXLA.xla!mymacro
 
B

Bob

Thanks Tom, I found that if the xla was selected in the
Tools|Add-ins dialog (ie loaded), then I only had to type
in the name of the macro in the assign macro step below.

Its strange that I can't see any of the add-in macros in
the assign macro dialog. is there a way to fix this?
 
T

Tom Ogilvy

No.

You can just type in the macro name if the name is unique among all the open
workbooks/addins. Usually better to be explicit.
 
Top