View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
external usenet poster
 
Posts: 747
Default Change Ribbon in Excel 2007

I'm trying to learn how to change the Excel 2007 ribbon. I have followed Ron
de Bruin's examples and others without success.

COMPUTER SPECIFICS:-

1. I'm running XP Professional version 5.1.2600 SP 3.

2. Installed are Microsoft .Net framework 1.1, 2.0 (SP2), 3.0 (SP2), 3.5
(SP1).

3. I have run the Windows Update Custom option to check for updates. None is
listed for .Net framework.

4. I'm using the Excel 2007 trial version.

5. I have downloaded and am using the Custom UI Editor.

6. Being connected to the internet when following the below steps doesn't
help.


EXAMPLE of FAILED EFFORT:-

1. I followed Ron de Bruin's intructions as per
"http://www.rondebruin.nl//ribbon.htm"

2. I create a new xl2007 format workbook and open it.

3. I create a standard code module in the workbook.

4. I paste callback code to the module (or do it later after steps 5 to 10).

5. I save the workbook as a macro-enabled workbook *.xlsm.

6. I close the workbook.

7. I then open the workbook using the Custom UI Editor.

8. I paste the same XML code copied from one of Ron's example workbooks or
use the Custom UI example code.

9. I save the XML by clicking the Save button in the UI Editor.

10. I open the *.xlsm workbook.

11. Nothing happens. This is true even if all callback code has been added.


OBSERVATIONS:-

In contrast, all of Ron's example workbooks work on my machine. The problem
appears to be with this line of code:

xmlns="http://schemas.microsoft.com/office/2006/01/customui"

If I use the Custom UI's validate feature, it responds with an error message
to the effect that the above is an unknown namespace and that it should be
".../2009/07/..." instead. If I change the above line to reference 2009/07
the validation feature accepts it. However, when I open the file, still
nothing happens.

Clueless and much appreciative of advice.

Greg Wilson