+ Reply to Thread
Results 1 to 4 of 4

Ribbon Customization - Unable to Edit Using Custom UI Editor

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    Upper Marlboro, Maryland
    MS-Off Ver
    Excel 2003
    Posts
    11

    Ribbon Customization - Unable to Edit Using Custom UI Editor

    To clarify, I have migrated a Personal Workbook with macros from a previous job to my current position almost two years ago. As part of that migration, I discovered the Custom UI Editor as my toolbars from my pre-ribbon workbook needed to be replaced. I know my macros are in the workbook, but I am no longer convinced by Ribbon Customizations are in there as well. I can see them in the customize ribbon dialog box, but if I try opening my workbook in the UI Editor, there are no customizations displayed.
    So my real question is, this: Is Office 365 saving my Ribbon customizations somewhere else and if so where. I wanted to import some custom icons using the UI Editor along with other tasks, but since I can't seem to even confirm where the custom ribbon items are, I am not sure what to do.
    I even renamed my personal workbook to .zip and examined the content as a compressed folder and found no evidence of any custom UI entries that we described in some online pages. I work with a lot of XML files so I am very comfortable looking at them and following their contents, which is why I like the custom UI editor as it allows me to work with XML files directly and handles all the file and folder manipulation for me.
    Last edited by caddcop; 06-03-2019 at 02:31 PM. Reason: Solution posted in reply!

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Ribbon Customization - Unable to Edit Using Custom UI Editor

    Unless you customised the ribbon using the CustomUI editor, there won't be anything there. If you did it manually in Excel, they are stored in the Excel.OfficeUI file.
    Rory

  3. #3
    Registered User
    Join Date
    01-04-2012
    Location
    Upper Marlboro, Maryland
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Ribbon Customization - Unable to Edit Using Custom UI Editor

    Thanks. I was not able to learn that tidbit via a number of Google Searches. It had been so long since I created the customizations that I just assumed I used the Custom UI tool as I have on other spreadsheets. Since my personal workbook loads on start for my macros, I figured I must have added those customizations to it. But I was wrong and you were correct. I gave you an Excel Forum thumbs up.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Ribbon Customization - Unable to Edit Using Custom UI Editor

    If you use the CustomUI with a hidden workbook (such as the personal macro workbook) that is not an add-in, the customisations don't show up anyway.

+ 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. [SOLVED] Get Backstage and Ribbon customization to work together
    By KiwiRickToo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2016, 09:03 PM
  2. Put VBA ribbon together with Custom UI Editor Ribbon
    By czarlando in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2016, 05:46 AM
  3. Exotic Ribbon Customization?
    By aquixano in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2015, 12:03 PM
  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. Ribbon Customization to Add Macros, macro keeps trying to run an older version
    By trishcollins in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2014, 11:17 AM
  6. Please help with 2013 ribbon customization
    By thetexan in forum Excel General
    Replies: 1
    Last Post: 07-06-2013, 12:21 PM
  7. Edit the Excel Ribbon - custom menu??
    By GeneralDisarray in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2011, 10:15 AM

Tags for this Thread

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