Ron,
I've done as you described in your examples, and I receive the following
error:
"Wrong number of arguments or invalid property assignment."
As previously mentioned, I've stored all of my macros in the MacroModule you
created with your custom menu we'd discussed before-- the RDB xlsb file-- I
have however changed the name to personal.xlsb.
Because of this, I've tried naming the OnAction="Macro1" two different ways.
1- onAction="personal.xlsb!Macro1"
2- onAction="Macro1"
where Macro1 is my own chosen name for the macro for my test.
The callback in the UI editor shows up fine, but I receive the same above
mentioned error each time.
In fact, for what it's worth, here is the callback statement I receive.
'Callback for button1 onAction
Sub GBS(control as IRibbonControl)
End Sub
I'll be among the first to say that my understanding is real limited here.
The general structure of my menu xlam file worksreally well. I just am not
understanding how to link the macros to the menu buttons/items.
For the sake of discussion I found some older macros that are in my old
personal.xls file.
I choose the same general configuration as above--
onAction="personal.xls!Macro1"
onAction="personal.Macro1"
And
onAction="Macro1"
The callback for the first is identical to the one pasted above.
The second and third give no callbacks.
All three, when activated in excel give me the error I state up top--
"wrong # of arguments, or invalid property."
Again, as always, thank you.
Best.
SteveB.
"Ron de Bruin" wrote:
> Hi Steve
>
> If you use my samples in the UI editor you can read that you can click
> on the create callbacks button to create the callbacks for every onaction
>
> Copy them in a module of your workbook and add your code
> http://www.rondebruin.nl/ribbon.htm
>
> From the site
>
> Generate Callbacks : This will create macros(callbacks) for each onAction you have in your xml.
> Select all callbacks and copy them in a normal module in your workbook.
> Try this in one of the examples and you will see that it is not so difficult.
> After that you can insert the code between the Sub and End Sub line in the macros(callbacks)
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "SteveDB1" <(E-Mail Removed)> wrote in message news:E8EC0841-05F6-4666-A8A7-(E-Mail Removed)...
> > Hello again.
> > I've finally got the menu structure for my customized ribbon menu.
> > Now I just need to connect the macros I have to each of the items/buttons.
> > As mentioned yesterday in my last post, I've read the pdf file from that
> > group in Britain--OALtd. While I see the "getItem..." components, I don't see
> > anything that specifically identifies how to connect my macros with the
> > components I made for the ribbon.
> > How can I do this?
> > My initialy thoughts would be to use the onAction="pathway to macro, and
> > macro name". I.e., c:\documents and settings\ user name\ application
> > data\microsoft\excel\xlstart\filename.xlsb!MacroName
> > However, the macros are stored in a structure based on ron DeBruin's
> > macro-module/menu.
> >
> > how do I accomplish this?
> > Thank you in advance.
> >
>
Similar Threads
