I am trying to create an add-in that creates a menu in Excel 2003 & 2007
each time an excel document is opened.

I have downloaded http://www.rondebruin.nl/compatiblemenu.htm - Example 3
is exactly the way I want it to work, BUT don't what to put the code in each
workbook.


I have tried saving the example "File A" as an add-in and copied it to the
XLSTART folder. This works fine in 2003, but in 2007 I get a Debug error
"rib.InvalidateControl "RDBGroup1".

Has anyone had success with loading from an add-in

Thanks
John

Hi JC

Do you want that the menu is there for every workbook ?


--

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


"JC" wrote in message ...
I am trying to create an add-in that creates a menu in Excel 2003 & 2007
each time an excel document is opened.

I have downloaded http://www.rondebruin.nl/compatiblemenu.htm - Example 3
is exactly the way I want it to work, BUT don't what to put the code in each
workbook.


I have tried saving the example "File A" as an add-in and copied it to the
XLSTART folder. This works fine in 2003, but in 2007 I get a Debug error
"rib.InvalidateControl "RDBGroup1".

Has anyone had success with loading from an add-in

Thanks
John

Wow - Ron de Bruin answering himself ..

That's correct , I've tried a number of different ways

e.g.. putting the `MacroModule', `mRibbon', `mXL' modules and the code in
this "ThisWorkbook" in a module (using Sub Auto_open) in a separate Start-up
add-in, but I can't get it to work in 2007. It works for 2003 but in Excel
2007 it show the debug error I previously mentioned.

Ideally, I would like 1 add-in file that will show the menus each time excel
is opened, all PC's with Office 2003 on have the 2007 compatibility pack
installed so they read a .xlam.

Thanks for the reply


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

Do you want that the menu is there for every workbook ?


--

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


"JC" wrote in message
...
I am trying to create an add-in that creates a menu in Excel 2003 & 2007
each time an excel document is opened.

I have downloaded http://www.rondebruin.nl/compatiblemenu.htm - Example
3 is exactly the way I want it to work, BUT don't what to put the code in
each workbook.


I have tried saving the example "File A" as an add-in and copied it to
the XLSTART folder. This works fine in 2003, but in 2007 I get a Debug
error "rib.InvalidateControl "RDBGroup1".

Has anyone had success with loading from an add-in

Thanks
John

Hi JC

I will test a few things with the compatibility pack installed on a 2003 machine and
see what the best solution is and get back to you this weekend

Good night


--

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


"JC" wrote in message ...
Wow - Ron de Bruin answering himself ..

That's correct , I've tried a number of different ways

e.g.. putting the `MacroModule', `mRibbon', `mXL' modules and the code in
this "ThisWorkbook" in a module (using Sub Auto_open) in a separate Start-up
add-in, but I can't get it to work in 2007. It works for 2003 but in Excel
2007 it show the debug error I previously mentioned.

Ideally, I would like 1 add-in file that will show the menus each time excel
is opened, all PC's with Office 2003 on have the 2007 compatibility pack
installed so they read a .xlam.

Thanks for the reply


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

Do you want that the menu is there for every workbook ?


--

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


"JC" wrote in message
...
I am trying to create an add-in that creates a menu in Excel 2003 & 2007
each time an excel document is opened.

I have downloaded http://www.rondebruin.nl/compatiblemenu.htm - Example
3 is exactly the way I want it to work, BUT don't what to put the code in
each workbook.


I have tried saving the example "File A" as an add-in and copied it to
the XLSTART folder. This works fine in 2003, but in 2007 I get a Debug
error "rib.InvalidateControl "RDBGroup1".

Has anyone had success with loading from an add-in

Thanks
John

Thanks Ron,

That works great! Please let me know when you update your site.

I guess to change the text on the 2007 ribbon ("Dynamic Menu" & the icon) to
say "Company Name" has to be done through the ribbon editor?

Again, thanks very much for your time.

John


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

With the compatibility pack installed on a 2003 machine you can copy
this 2007 add-in in the XLStart folder and it will create the menu on the
worksheet menubar.

If you not see the attachment in this thread mail me private and i send it
to you

If you install it in 2007 you see a new menu on the Home Tab

Let me know if it is working for you.
I will make a better example and add it to my site this weekend


--

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


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

I will test a few things with the compatibility pack installed on a 2003
machine and
see what the best solution is and get back to you this weekend

Good night


--

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


"JC" wrote in message
...
Wow - Ron de Bruin answering himself ..

That's correct , I've tried a number of different ways

e.g.. putting the `MacroModule', `mRibbon', `mXL' modules and the code
in
this "ThisWorkbook" in a module (using Sub Auto_open) in a separate
Start-up
add-in, but I can't get it to work in 2007. It works for 2003 but in
Excel
2007 it show the debug error I previously mentioned.

Ideally, I would like 1 add-in file that will show the menus each time
excel
is opened, all PC's with Office 2003 on have the 2007 compatibility pack
installed so they read a .xlam.

Thanks for the reply


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

Do you want that the menu is there for every workbook ?


--

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


"JC" wrote in message
...
I am trying to create an add-in that creates a menu in Excel 2003 &
2007
each time an excel document is opened.

I have downloaded http://www.rondebruin.nl/compatiblemenu.htm -
Example
3 is exactly the way I want it to work, BUT don't what to put the code
in
each workbook.


I have tried saving the example "File A" as an add-in and copied it to
the XLSTART folder. This works fine in 2003, but in 2007 I get a Debug
error "rib.InvalidateControl "RDBGroup1".

Has anyone had success with loading from an add-in

Thanks
John

Hi JC

I guess to change the text on the 2007 ribbon ("Dynamic Menu" & the icon) to
say "Company Name" has to be done through the ribbon editor?
Yes

I will create a good example this week and reply in this thread when it
is online.



--

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


"JC" wrote in message ...
Thanks Ron,

That works great! Please let me know when you update your site.

I guess to change the text on the 2007 ribbon ("Dynamic Menu" & the icon) to
say "Company Name" has to be done through the ribbon editor?

Again, thanks very much for your time.

John


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

With the compatibility pack installed on a 2003 machine you can copy
this 2007 add-in in the XLStart folder and it will create the menu on the
worksheet menubar.

If you not see the attachment in this thread mail me private and i send it
to you

If you install it in 2007 you see a new menu on the Home Tab

Let me know if it is working for you.
I will make a better example and add it to my site this weekend


--

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


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

I will test a few things with the compatibility pack installed on a 2003
machine and
see what the best solution is and get back to you this weekend

Good night


--

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


"JC" wrote in message
...
Wow - Ron de Bruin answering himself ..

That's correct , I've tried a number of different ways

e.g.. putting the `MacroModule', `mRibbon', `mXL' modules and the code
in
this "ThisWorkbook" in a module (using Sub Auto_open) in a separate
Start-up
add-in, but I can't get it to work in 2007. It works for 2003 but in
Excel
2007 it show the debug error I previously mentioned.

Ideally, I would like 1 add-in file that will show the menus each time
excel
is opened, all PC's with Office 2003 on have the 2007 compatibility pack
installed so they read a .xlam.

Thanks for the reply


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

Do you want that the menu is there for every workbook ?


--

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


"JC" wrote in message
...
I am trying to create an add-in that creates a menu in Excel 2003 &
2007
each time an excel document is opened.

I have downloaded http://www.rondebruin.nl/compatiblemenu.htm -
Example
3 is exactly the way I want it to work, BUT don't what to put the code
in
each workbook.


I have tried saving the example "File A" as an add-in and copied it to
the XLSTART folder. This works fine in 2003, but in 2007 I get a Debug
error "rib.InvalidateControl "RDBGroup1".

Has anyone had success with loading from an add-in

Thanks
John

Hi JC

Do you have time to test a tester ?
Mail me private if you have time to test a file for me

I want to see if it is easy to work with my test add-in

--

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


"JC" wrote in message ...
Thanks Ron,

That works great! Please let me know when you update your site.

I guess to change the text on the 2007 ribbon ("Dynamic Menu" & the icon) to
say "Company Name" has to be done through the ribbon editor?

Again, thanks very much for your time.

John


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

With the compatibility pack installed on a 2003 machine you can copy
this 2007 add-in in the XLStart folder and it will create the menu on the
worksheet menubar.

If you not see the attachment in this thread mail me private and i send it
to you

If you install it in 2007 you see a new menu on the Home Tab

Let me know if it is working for you.
I will make a better example and add it to my site this weekend


--

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


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

I will test a few things with the compatibility pack installed on a 2003
machine and
see what the best solution is and get back to you this weekend

Good night


--

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


"JC" wrote in message
...
Wow - Ron de Bruin answering himself ..

That's correct , I've tried a number of different ways

e.g.. putting the `MacroModule', `mRibbon', `mXL' modules and the code
in
this "ThisWorkbook" in a module (using Sub Auto_open) in a separate
Start-up
add-in, but I can't get it to work in 2007. It works for 2003 but in
Excel
2007 it show the debug error I previously mentioned.

Ideally, I would like 1 add-in file that will show the menus each time
excel
is opened, all PC's with Office 2003 on have the 2007 compatibility pack
installed so they read a .xlam.

Thanks for the reply


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

Do you want that the menu is there for every workbook ?


--

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


"JC" wrote in message
...
I am trying to create an add-in that creates a menu in Excel 2003 &
2007
each time an excel document is opened.

I have downloaded http://www.rondebruin.nl/compatiblemenu.htm -
Example
3 is exactly the way I want it to work, BUT don't what to put the code
in
each workbook.


I have tried saving the example "File A" as an add-in and copied it to
the XLSTART folder. This works fine in 2003, but in 2007 I get a Debug
error "rib.InvalidateControl "RDBGroup1".

Has anyone had success with loading from an add-in

Thanks
John

I update the page with a example
http://www.rondebruin.nl/compatiblemenu.htm


--

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


"JC" wrote in message ...
I am trying to create an add-in that creates a menu in Excel 2003 & 2007
each time an excel document is opened.

I have downloaded http://www.rondebruin.nl/compatiblemenu.htm - Example 3
is exactly the way I want it to work, BUT don't what to put the code in each
workbook.


I have tried saving the example "File A" as an add-in and copied it to the
XLSTART folder. This works fine in 2003, but in 2007 I get a Debug error
"rib.InvalidateControl "RDBGroup1".

Has anyone had success with loading from an add-in

Thanks
John