Custom UI Editor

Adding a customised Ribbon to your Office files means inserting an XML component into the Open Office XML file format.
The steps to add this XML component is documented here.
The Custom UI Editor was a tool created by Microsoft that would simplify adding the necessary XML component.
This editor can be used for all Ribbon Customisations stored in the Office Open XML Format.
This includes individual workbooks and documents as well as add-ins and templates.
You can download the EXE file here OfficeCustomUIEditorFiles.zip


Download and Change the Config File

Download the .zip file and copy the files to a local subfolder.
For example this could be "C:\Temp\CustomUIEditor\".
The application configuration file contains an entry that specifies the .NET Framework version "v2.0.50727".
If this .NET Framework version cannot be found on your machine, the Custom UI Editor application will not run.
You will be able to get it to run by changing the configuration file to specify a more recent version of the .NET Framework.
Drag the configuration file into NotePad and change the "v2.0.50727" to "v4.0" instead.

Double click on the .exe file C:\Temp\CustomUIEditor\CustomUIEditor.exe


Creating an Excel Workbook with a Custom Ribbon

More details can be found here Document Level > Editor


Creating an Excel Add-in with a Custom Ribbon

More details can be found here Application Level > Editor


Reference

You can download the MSI installation file here OfficeCustomUIEditorSetup.zip


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext