Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys
In XL2003 with custom toolbars, I could assign an OnAction macro with an argument, something like .OnAction = "'MyMacro "SomeArgumentHere"'" From memory, the argument is wrapped in double quotes, the entire macro and argument is wrapped in single quotes and double quotes around that. It might have been slightly different, but you get the idea. What I'm trying to do now is, in XL2007, customise the ribbon similarly. But the syntax in XML is different and I'm wondering how you wrap the argument. Any suggestions are appreciated. Thanks in advance Paul Martin Melbourne, Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign Macro to Ribbon Button | Excel Programming | |||
no custom button in ribbon | Excel Programming | |||
Macro Fault on Custom Ribbon | Excel Programming | |||
error running macro from Ribbon button | Excel Programming | |||
Hyperlink calls macro passing argument | Excel Programming |