+ Reply to Thread
Results 1 to 2 of 2

Excel Ribbon without Office Custom UI tool

  1. #1
    Registered User
    Join Date
    08-31-2015
    Location
    UK
    MS-Off Ver
    2007/2010
    Posts
    22

    Excel Ribbon without Office Custom UI tool

    Hi, Guys.

    Is theer a way to create custtom excel ribbons without using the Office Custom UI tool? E.g. Somehow run code on the relevant xml that contains the ribbon definition?

    Thanks.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Excel Ribbon without Office Custom UI tool

    You can certainly write vba code to manipulate the xml and res files. But you can not do it on an open workbook.

    Access stores the ribbon xml in a table and there is much simpler to write custom xml on the fly. Unfortunately excel does not allow the same.

    More information about the xml here.
    https://msdn.microsoft.com/en-us/library/aa338202.aspx
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Custom Ribbon Tabs without Custom UI tool
    By edmunda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2016, 04:39 AM
  2. [SOLVED] Custom Excel Ribbon
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-18-2016, 02:40 PM
  3. [SOLVED] Updating a custom ribbon for an excel Add in
    By nburton in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2016, 08:46 AM
  4. Assistance with Custom Tab and Groups on Excel Office Ribbon using Custom UI Editor.
    By sdavison in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2015, 06:13 AM
  5. Excel Custom Ribbon
    By TheRobsterUK in forum Excel General
    Replies: 0
    Last Post: 12-11-2014, 06:11 AM
  6. [SOLVED] An alternative to the Add-Ins ribbon tab - Global Custom Ribbon Tab by Ken Puls
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2014, 10:01 PM
  7. Microsoft Office Data Analyisis tool pack for excel
    By b5brooke in forum Excel General
    Replies: 0
    Last Post: 02-20-2006, 02:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1