Tag Archives | Customisation

Customising the Office Ribbon

Those of you who use Office 2010 and 2013 are probably quite happy with the Ribbon customisation options offered in those versions. Office 2007 had the Ribbon but no customisation at all.

What if you want to add sub-menus? This is not possible in the 2010 and 2013 user-interfaces and according to Microsoft you really need to program in Visual Studio .NET to get these extra customisations; however, I found an article written way back in 2009 that I want to bring to your attention that still works and gives some really cool customisations using VBA and a little XML. Now don’t panic at the thought of the XML as the article explains it all.

Take a look at the step-by-step guide to customising the Office Ribbon

Customising the Quick Access Toolbar

You have all probably customised the Quick Access Toolbar (QAT), but I find many people have failed to notice they can assign buttons to specific documents so the button only appear in the QAT when that document I open. This works in all Office applications except Outlook and OneNote.

Firstly open the document, worksheet etc. to which you want to attached specific QAT buttons.

Customise the Quick access Toolbar as normal but before you add any specific buttons make sure that you select the document in the top-right drop-down selector rather than using the default All Documents option.

Complete the customisation process adding any buttons as required.

Finally, close your document and make sure that you save the changes as the button are saved with the document.