Assigning add-in function to custom button
 

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?

Assigning add-in function to custom button
 

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

MyXLA.xla!mymacro

--
Regards,
Tom Ogilvy

"Robert" wrote in message
...
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?

Assigning add-in function to custom button
 

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?

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

MyXLA.xla!mymacro

--
Regards,
Tom Ogilvy

"Robert" wrote in
message
...
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?


.

Assigning add-in function to custom button
 

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.

--
Regards,
Tom Ogilvy

Bob wrote in message
...
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?

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

MyXLA.xla!mymacro

--
Regards,
Tom Ogilvy

"Robert" wrote in
message
...
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?


.