View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Excel 2003 & 2007 menu compatible menu by 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


--

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