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