LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Ribbon hitmonkong Excel Programming 5 September 17th 09 12:32 PM
Excel 2007 Ribbon Annette[_3_] Excel Discussion (Misc queries) 4 August 25th 09 02:39 PM
Ribbon in Excel 2007 [email protected] Excel Programming 0 June 4th 09 02:22 PM
Excel 2007 | Add-Ins Ribbon ac1179 Excel Programming 1 March 30th 09 07:18 PM
How can I add the OneNote 2007 icon to the ribbon in Excel 2007? Todd Excel Discussion (Misc queries) 6 February 14th 08 11:22 PM


All times are GMT +1. The time now is 02:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"