Excel 2003 & 2007 menu compatible menu by Ron de Bruin

[JC]

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

 

[Ron de Bruin]

Hi JC

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

 

[JC]

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]

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

 

[JC]

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]

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.

 

[Ron de Bruin]

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

 

[Ron de Bruin]

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