« Beta Testers For PUP v7?
Subtotals to summarize data »

Excel 2007 Menu

20th January 2007, 07:28 am by Ron de Bruin

Hi all

I add two pages to my site to create a menu in Excel 2007.

I changed John Walkenbach‘s superb menu maker example for 97-2003 to create the PopUp menu.
Very easy to add and edit menu items with this technique.

For one workbook
http://www.rondebruin.nl/qat2.htm

Menu for all your workbooks
http://www.rondebruin.nl/qat.htm

Suggestions are welcome

Ron de Bruin
http://www.rondebruin.nl/tips.htm

Category: General, CommandBars  |  Comment (RSS)  |  Trackback

5 Comments

  1. Mike Alexander:

    Very creative workaround Ron! Very nice.

    21 January 2007, 4:47 am

  2. Ron de Bruin:

    Hi all

    I add a new page to my site : Change the ribbon in Excel 2007

    Suggestions are welcome
    I will add more examples when I have time and ideas.

    http://www.rondebruin.nl/ribbon.htm

    Have fun

    31 January 2007, 4:21 pm

  3. Mangesh:

    Hi,

    I would like to remove office button from excel 2007, please help if possible.

    21 August 2007, 2:50 am

  4. Ron de Bruin:

    Hi all

    I update this page with a add-in example

    Menu for all your workbooks
    http://www.rondebruin.nl/qat.htm

    Easier now I think ?
    Let me know if you not agree

    3 January 2008, 5:17 pm

  5. Ron de Bruin:

    Hi Mangesh

    There are examples on my ribbon page to disable all
    controls on the office button menu.

    See the dictator examples in the download on my page
    http://www.rondebruin.nl/ribbon.htm
    See number 2

    3 January 2008, 5:20 pm

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment