Custom UI Editor

2

25INF

New Member
Joined
Jan 12, 2018
Messages
13
I wrote a .xml file in Custom UI editor and it works fine in windows 10. No problems. I put the same spreadsheet on my friends computer and it also worked fine until IT put windows 11 on his computer. The UI editor validates the .xml file as all as correct in windows 11 but it doesn't show anything when opening up the excel workbook. Anybody have any ideas what could be happening?
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
Excel Formula: 
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
   <ribbon>
      <tabs>
         <tab id="Tab1" insertBeforeMso="TabHome" label="Pilot">
            <group id="Grp1">
                <splitButton id="Grp1Sb1" size="large">
                    <button id = "Grp1Sb1Btn1" label="Setup" imageMso="FileDocumentEncrypt" onAction="modRibbon.ctlSetup"/>
                        <menu id="Grp1Sb1Menu1" itemSize="normal" >
                            <button id="Grp1Sb1Btn2" label="Open Properties" imageMso="ColorBlue" onAction="modRibbon.ctlSetup" />
                            <button id="Grp1Sb1Btn3" label="Update Properties" imageMso="ColorBlue" onAction="modRibbon.ctlSetup" />
                            <button id="Grp1Sb1Btn4" label="Hide Properties" imageMso="ColorBlue" onAction="modRibbon.ctlSetup" />
                        </menu>
                </splitButton> 
            </group>
            <group id="Grp2" label="Transactions"> 
                <splitButton id="Grp2Sb1" size="large" >
                    <button id="Grp2Sb1Btn1" label="Open" imageMso="FileNewDocument" onAction="modRibbon.ctlQueryOpen"/>
                        <menu id="Grp2Sb1Menu1" itemSize="normal" >
                            <button id="Grp2Sb1Btn2" label="Query Open" imageMso="ColorBlue" onAction="modRibbon.ctlQueryOpen" />
                            <button id="Grp2Sb1Btn3" label="Assign Open" imageMso="AssignTask" onAction="modRibbon.ctlQueryOpen" />
                            <button id="Grp2Sb1Btn4" label="Email Open" imageMso="SharingOpenMailFolder" onAction="modRibbon.ctlQueryOpen" />
                        </menu>
               </splitButton> 
               <splitButton id="Grp2Sb2" size="large" >
                    <button id="Grp2Sb2Btn1" label="Ready" imageMso="MailMergeFinishAndMergeMenu" onAction="modRibbon.ctlQueryReady"/>
                        <menu id="Grp2Sb2Menu1" itemSize="normal" >
                            <button id="Grp2Sb2Btn2" label="Query Ready" imageMso="ColorBlue" onAction="modRibbon.ctlQueryReady" />
                            <button id="Grp2Sb2Btn3" label="Assign Ready" imageMso="AssignTask" onAction="modRibbon.ctlQueryReady" />
                            <button id="Grp2Sb2Btn4" label="Rev Ready [ctrl + down]" imageMso="MailMergeAutoCheckForErrors" onAction="modRibbon.ctlQueryReady" />
                        </menu>
               </splitButton>     
               <splitButton id="Grp2Sb3" size="normal" >
                    <button id="Grp2Sb3Btn1" label="Schedule" imageMso="MonthlyView" onAction="modRibbon.ctlQuerySched"/>
                        <menu id="Grp2Sb3Menu1" itemSize="normal" >
                            <button id="Grp2Sb3Btn2" label="IW37N, Query Weekly" imageMso="AssignTask" onAction="modRibbon.ctlQuerySched"/>
                            <button id="Grp2Sb3Btn3" label="Weekly Print List" imageMso="AssignTask" onAction="modRibbon.ctlQuerySched"/>
                            <button id="Grp2Sb3Btn4" label="IW37N, Query KMDD" imageMso="AssignTask" onAction="modRibbon.ctlQuerySched" />
                            <button id="Grp2Sb3Btn5" label="KMDD Print List" imageMso="AssignTask" onAction="modRibbon.ctlQuerySched"/>
                            <button id="Grp2Sb3Btn6" label="IW37N, Query AO" imageMso="AssignTask" onAction="modRibbon.ctlQuerySched" />
                            <button id="Grp2Sb3Btn7" label="AO Print List" imageMso="AssignTask" onAction="modRibbon.ctlQuerySched"/>
                        </menu>
               </splitButton>  
               <splitButton id="Grp2Sb4" size="normal" >
                    <button id="Grp2Sb4Btn1" label="General" imageMso="DatabaseSqlServer" onAction="modRibbon.ctlTransGen"/>
                        <menu id="Grp2Sb4Menu1" itemSize="normal" >
                            <button id="Grp2Sb4Btn2" label="IW31, Create Order" imageMso="AssignTask" onAction="modRibbon.ctlTransGen"/>
                            <button id="Grp2Sb4Btn3" label="ZMMC, Material Information" imageMso="AssignTask" onAction="modRibbon.ctlTransGen"/>
                            <button id="Grp2Sb4Btn4" label="ZMR26, Material Search" imageMso="AssignTask" onAction="modRibbon.ctlTransGen" />
                            <button id="Grp2Sb4Btn5" label="IH01, FLOC" imageMso="AssignTask" onAction="modRibbon.ctlTransGen"/>
                            <button id="Grp2Sb4Btn6" label="ME23N, Display PO" imageMso="AssignTask" onAction="modRibbon.ctlTransGen" />
                            <button id="Grp2Sb4Btn7" label="MK03, Display Vendor" imageMso="AssignTask" onAction="modRibbon.ctlTransGen"/>
                        </menu>
               </splitButton> 
               <editBox id="Grp2ebx1" imageMso="DateAndTimeInsert" onChange="modRibbon.ctlRev"/>      
            </group >
            <group id="Grp3" label="Tools">
               <splitButton id="Grp3Sb1" size="normal" >
                    <button id="Grp3Sb1Btn1" label="Print" imageMso="PrintDialogAccess" onAction="modRibbon.ctlPrint"/>
                        <menu id="Grp3Sb1Menu1" itemSize="normal" >
                            <button id="Grp3Sb1Btn2" label="Print WO" imageMso="PrintDialogAccess" onAction="modRibbon.ctlPrint" />
                            <button id="Grp3Sb1Btn3" label="Print JP" imageMso="PrintDialogAccess" onAction="modRibbon.ctlPrint" />
                            <button id="Grp3Sb1Btn4" label="Print Folder Labels" imageMso="PrintDialogAccess" onAction="modRibbon.ctlPrint" />
                            <button id="Grp3Sb1Btn5" label="Print PM02" imageMso="PrintDialogAccess" onAction="modRibbon.ctlPrint" />
                        </menu>
               </splitButton>
               <button id="Grp3Btn2" label="Attach" imageMso="ArrangeByAttachment" onAction="modRibbon.ctlAttach" />    
               <button id="Grp3Btn3" label="File" imageMso="RulesManager" onAction="modRibbon.ctlFile" /> 
               <separator id="Grp3Sep1" />
               <splitButton id="Grp3Sb2" size="normal" >
                    <button id="Grp3Sb2Btn1" label="Shortcuts" imageMso="HelpKeyboardShortcuts"/>
                        <menu id="Grp3Sb2Menu1" itemSize="normal" >
                            <button id="Grp3Sb2Btn2" label="Open WO [ctrl + left]" imageMso="HelpKeyboardShortcuts" onAction="modRibbon.ctlShortcuts" />
                            <button id="Grp3Sb2Btn3" label="Open File [ctrl + down]" imageMso="HelpKeyboardShortcuts" onAction="modRibbon.ctlShortcuts" />
                            <button id="Grp3Sb2Btn4" label="Open SAP [ctrl + right]" imageMso="HelpKeyboardShortcuts" onAction="modRibbon.ctlShortcuts" />
                            <button id="Grp3Sb2Btn5" label="Email WO [ctrl + up]" imageMso="HelpKeyboardShortcuts" onAction="modRibbon.ctlShortcuts" />
                        </menu>
               </splitButton>
               <splitButton id="Grp3Sb3" size="normal" >
                    <button id="Grp3Sb3Btn1" label="Filter Stat" imageMso="ApplyFilter" onAction="modRibbon.ctlFilterStat"/>
                        <menu id="Grp3Sb3Menu1" itemSize="normal" >
                            <button id="Grp3Sb3Btn2" label="Filter Stat" imageMso="ColorBlue" onAction="modRibbon.ctlFilterStat" />
                            <button id="Grp3Sb3Btn3" label="Archive Fini" imageMso="ColorBlue" onAction="modRibbon.ctlFilterStat" />
                        </menu>
               </splitButton>    
               <editBox id="Grp3ebx1" imageMso="NetworkDiagramZoom" onChange="modRibbon.ctlSearch"/>  
               <separator id="Grp3Sep2" />
               <button id="Grp3Btn4" size="normal" label="Upload" imageMso="UploadAttachmentToOneDrive" onAction="modRibbon.ctlUpload" /> 
               <splitButton id="Grp3Sb4" size="normal" >
                    <button id="Grp3Sb4Btn1" label="Update" imageMso="RefreshMeetingDetails" onAction="modRibbon.ctlUpdate"/>
                        <menu id="Grp3Sb4Menu1" itemSize="normal" >
                            <button id="Grp3Sb4Btn2" label="Update All" imageMso="RefreshMeetingDetails" onAction="modRibbon.ctlUpdate" />
                        </menu>
               </splitButton>  
               <toggleButton id="Grp3tgl1" size="normal" label="Highlight" imageMso="ColorBlue" onAction="modRibbon.ctlHighlight"  />
            </group>
            <group id="Grp4" label="Accounting">    
               <splitButton id="Grp4Sb1" size="large" >
                    <button id="Grp4Sb1Btn1" label="Check Book" imageMso="AccountingFormat" onAction="modRibbon.ctlCheck"/>
                        <menu id="Grp4Sb1Menu1" itemSize="normal" >
                            <button id="Grp4Sb1Btn2" label="Check Book" imageMso="AccountingFormat" onAction="modRibbon.ctlCheck" />
                            <button id="Grp4Sb1Btn3" label="ISN" imageMso="EnterpriseProjectProfiles" onAction="modRibbon.ctlCheck" />
                        </menu>
               </splitButton>   
               <button id="Grp4Btn1" label="Write" imageMso="GroupPensWrite" size="normal" onAction="modRibbon.ctlCheck" />
               <button id="Grp4Btn2" label="Validate" imageMso="RulesToCheck" size="normal" onAction="modRibbon.ctlCheck" />
               <button id="Grp4Btn3" label="Publish" imageMso="MenuPublish" size="normal" onAction="modRibbon.ctlCheck" />  
            </group>     
            <group id="Grp5" label="Bill of Material">    
               <button id="Grp5Btn1" label="Material Master" imageMso="MasterDocument" size="large" onAction="modRibbon.ctlBom" />  
               <button id="Grp5Btn2" label="See Stores" imageMso="ExternalDataWindow" size="normal" onAction="modRibbon.ctlBom" />
               <splitButton id="Grp5Sb1" size="normal" >
                    <button id="Grp5Sb1Btn1" label="See FLOC" imageMso="GetExternalDataImportClassic" onAction="modRibbon.ctlBom"/>
                        <menu id="Grp5Sb1Menu1" itemSize="normal" >
                            <button id="Grp5Sb1Btn2" label="See FLOC" imageMso="GetExternalDataImportClassic" onAction="modRibbon.ctlBom" />
                            <button id="Grp5Sb1Btn3" label="Generate FLOC" imageMso="GetExternalDataImportClassic" onAction="modRibbon.ctlBom" />
                        </menu>
               </splitButton>
               <splitButton id="Grp5Sb2" size="normal" >
                    <button id="Grp5Sb2Btn1" label="Change BOM" imageMso="AutoFormat" onAction="modRibbon.ctlBom"/>
                        <menu id="Grp5Sb2Menu1" itemSize="normal" >
                            <button id="Grp5Sb2Btn2" label="Change BOM" imageMso="ColorBlue" onAction="modRibbon.ctlBom" />
                            <button id="Grp5Sb2Btn3" label="Create BOM" imageMso="ColorBlue" onAction="modRibbon.ctlBom" />
                        </menu>
               </splitButton>  
            </group>
            <group id="Grp6" label="Reference">    
                <splitButton id="Grp6Sb1" size="normal" >
                    <button id="Grp6Sb1Btn1" label="Contacts" imageMso="OpenSharedContacts"/>
                        <menu id="Grp6Sb1Menu1" itemSize="normal" >
                            <button id="Grp6Sb1Btn2" label="export" imageMso="ColorBlue" onAction="modRibbon.ctlContacts" />
                        </menu>
               </splitButton> 
               <splitButton id="Grp6Sb2" size="normal" >
                    <button id="Grp6Sb2Btn1" label="Website" imageMso="OtherWebLocationsShortcutMenu"/>
                        <menu id="Grp6Sb2Menu1" itemSize="normal" >
                            <button id="Grp6Sb2Btn2" label="weekly Schedule" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                            <button id="Grp6Sb2Btn3" label="KMDD Schedule" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                            <button id="Grp6Sb2Btn4" label="Checkbook" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                            <button id="Grp6Sb2Btn5" label="Material Master" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                            <button id="Grp6Sb2Btn6" label="ISN" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                            <button id="Grp6Sb2Btn7" label="Contacts" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                            <button id="Grp6Sb2Btn8" label="Pictures" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                            <button id="Grp6Sb2Btn9" label="AOSS" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                            <button id="Grp6Sb2Btn10" label="Capex" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                            <button id="Grp6Sb2Btn11" label="Major Maintenance" imageMso="ColorBlue" onAction="modRibbon.ctlWebsite" />
                        </menu>
               </splitButton>     
               <splitButton id="Grp6Sb3" size="normal" >
                    <button id="Grp6Sb3Btn1" label="Library" imageMso="GroupGetExternalData"/>
                        <menu id="Grp6Sb3Menu1" itemSize="normal" >
                            <button id="Grp6Sb3Btn2" label="OSD" imageMso="ColorBlue" onAction="modRibbon.ctlLibrary" />
                            <button id="Grp6Sb3Btn3" label="forms" imageMso="ColorBlue" onAction="modRibbon.ctlLibrary" />
                        </menu>
               </splitButton>   
            </group>       
        </tab>
      </tabs>
   </ribbon>
</customUI>
 
Upvote 0
You don’t mention what version of office you are using
Have you tried simplifying the code down to one button to try to get that working
I would also check if the mso images are loaded by default on the new pc there is plenty of sample code around
Is the security enabled for the target macro set
 
Upvote 0
I did try some sample code on a new workbook using the office ribbonX editor. No luck. I'll have to ask the guy what version of office is on his computer after he returns. I'm still able to run the macros from the developer tab. Is there something IT could have blocked when they updated him to windows 11?
 
Upvote 0
I would start from basics with a simple button and see if that works, then add button image and finally add a macro call so you can see at what stage it is failing
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Custom UI Tab Not Working
Replies
7
Views
847
Dman333
D
M
  • Question Question
Help with Solution better than nested IF
Replies
1
Views
678
Zaifee
Z
A
  • Question Question
MS Word macro to find text from Excel list in Word doc, then copy and paste chunks from Word doc to new Word doc
Replies
3
Views
2K
amaneta67
A
MCLIFTO8
  • Question Question
Article / Guide feedback requested. The best way to learn Excel.
Replies
0
Views
1K
MCLIFTO8
MCLIFTO8
S
  • Question Question
Excel crashes when clicking object in the locals window od the VB Editor.
Replies
4
Views
234
Edgar_
Edgar_

Forum statistics

Threads
1,223,983
Messages
6,175,778
Members
452,668
Latest member
mrider123

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top