Add-Ins macros assignment

[basilio]

how can I assign my "myAddIns" macros to a specific button on a worksheet?
the "myAddIns" file has been saved as an addin and it appears to the addin
listing, but no way upt to now o make it work.
Can anybody help??
Thanks a lot.
--
Basilio

[Bob Phillips]

Why not get the addin to add the buttons themselves, then it is a simple
OnAction assignment.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"basilio" <basilio@discussions.microsoft.com> wrote in message
news:2FB9F64A-F19D-455A-88DB-13F7A5351B77@microsoft.com...
> how can I assign my "myAddIns" macros to a specific button on a worksheet?
> the "myAddIns" file has been saved as an addin and it appears to the addin
> listing, but no way upt to now o make it work.
> Can anybody help??
> Thanks a lot.
> --
> Basilio

[Tom Ogilvy]

in the assign macro box, just type in the the name of your addin in the same
format it would appear in Tools=>Macro=Macros for a non - active workbook if
it were a workbook. for example:

Myaddins.xls!MyMacro

--
Regards,
Tom Ogilvy


"basilio" wrote:

> how can I assign my "myAddIns" macros to a specific button on a worksheet?
> the "myAddIns" file has been saved as an addin and it appears to the addin
> listing, but no way upt to now o make it work.
> Can anybody help??
> Thanks a lot.
> --
> Basilio

[basilio]

thanks a lot guys.
both solutions may be used in my applications and they are exactly what I
needed.
thanks again
---
Basilio


"Tom Ogilvy" wrote:

> in the assign macro box, just type in the the name of your addin in the same
> format it would appear in Tools=>Macro=Macros for a non - active workbook if
> it were a workbook. for example:
>
> Myaddins.xls!MyMacro
>
> --
> Regards,
> Tom Ogilvy
>
>
> "basilio" wrote:
>
> > how can I assign my "myAddIns" macros to a specific button on a worksheet?
> > the "myAddIns" file has been saved as an addin and it appears to the addin
> > listing, but no way upt to now o make it work.
> > Can anybody help??
> > Thanks a lot.
> > --
> > Basilio