Btw: the xml to create the menu is not working in your personal.xlsb.
You can make it a add-in

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Hi Steve

Send me your file private steve then I look at it


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"SteveDB1" wrote in message ...
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" wrote in message ...
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!MacroNa me
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.