G
Greg Wilson
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
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