Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Ribbon | Excel Programming | |||
Excel 2007 Ribbon | Excel Discussion (Misc queries) | |||
Ribbon in Excel 2007 | Excel Programming | |||
Excel 2007 | Add-Ins Ribbon | Excel Programming | |||
How can I add the OneNote 2007 icon to the ribbon in Excel 2007? | Excel Discussion (Misc queries) |