ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add-Ins macros assignment (https://www.excelbanter.com/excel-programming/360446-add-ins-macros-assignment.html)

basilio

Add-Ins macros assignment
 
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[_14_]

Add-Ins macros assignment
 
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" wrote in message
...
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

Add-Ins macros assignment
 
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

Add-Ins macros assignment
 
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



All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com