#Custom ui editor for microsoft office how to#
#Custom ui editor for microsoft office zip file#
#Custom ui editor for microsoft office archive#

' Removes the customUI folder from the specified Office file. ' When finished coding, change back to False and remove the reference ' To use IntelliSense when coding, change this to True and add references to: Here is the full code before we look at it in detail after:

#Custom ui editor for microsoft office zip file#

We’re going to use an instance of the Windows Shell application to set a reference to the Folder object and then look inside the Zip file to then manipulate it’s contents. The above process looks straight forward but manipulating Zip files in VBA is a relatively unknown area of Windows.

#Custom ui editor for microsoft office archive#

To remove the customUI it’s simply a case of deleting the customUI folder from the Zip archive before renaming it back to the original Office document name, without the. customUI14.xml : Office 2010 and onwards (to 2016 as of writing this article).If you then open the customUI folder, you’ll see one or more of these files which define the UI customisation: zip and then explore the contents of the file archive using Windows Explorer or any third party Zip file tool.įor a relatively simple Office file, let’s use PowerPoint as an example, you’ll then see a structure like this: For anyone unaware of the Office file formats, you can simply rename any XML-based Office file (the standard format since Office 2007) to. Our solution overviewĭoing this manually is quite a simple task. This then leads to the need to remove that customUI part from the XML file that represents your Office document. However, when you then open that non-macro enabled file, it still includes the ribbon customisation in the customUI XML part so your UI callbacks won’t find the corresponding code in the non-existent VBA project any more. Programmatically saving a copy of the macro-enabled file causes the VBA project to be automatically deleted from the file so that part is easily taken care of. When you add a ribbon customisation (customUI part) to a macro-enabled Office file such as PowerPoint (.pptm), Excel (.xlsm) or Word (.docm) which includes callback to embedded VBA code, you may want to publish the finished file as a non-macro enabled file format e.g. PowerPoint (.pptx), Excel (.xlsx) or Word (.docx). Why do we need to do this?įirstly, let’s explore why the need arose.

#Custom ui editor for microsoft office how to#

We came across the need to remove ribbon customisation from a macro-enabled Office file recently and spent some time researching how to do it and coming up with a neat solution which we’re sharing here.

Free Speaking Teaching Clock for PowerPoint.

Free PowerPoint Digital Clock, Alarm & Countdown.

PPTEXPIRE : PowerPoint Presentation Expiry Date.

CIRCLIFY : PowerPoint circular & spiral graphics.

Org Chart Designer : Excel to PowerPoint.

YOUtools : smart design tools for smart designers.

VICONS : Editable icons for Microsoft Office.

VMAPS : Editable maps and heat maps for PowerPoint.

ACTIVEPREZ : Non-Linear PowerPoint Navigation.