Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Key Assignment Log | Excel Discussion (Misc queries) | |||
Trouble with Macros Assignment- anyone willing to help? | Excel Programming | |||
Trouble with Macros Assignment- anyone willing to help? | Excel Programming | |||
Trouble with Macros Assignment- anyone willing to help? | Excel Programming | |||
Assignment by reference or value | Excel Programming |