Office Watch

Office 2013

Office Mobile / iPad

Office 2010

Office 2007

Office 2003

Office XP

Office for Mere Mortals

Access

Email

Buying Office

Office 365

Winks

Office News Wire

Join us!

Our Ebooks

Mobile | PDA

RSS


Search

Command Finder


Microsoft Office Bookshop

About

Home




Adding to the Customize Command List

Why the Office command list isn’t comprehensive and how to add ‘missing’ items.

by Office Watch

Bookmark and Share

  | Mobile | click for more article services     


Our Command Finder list is the list supplied by Microsoft in the command customization dialog. We've provided an easier way to find that information but are limited to what Redmond has provided all Office users.

Not everything is exposed in the Customize command list. Some features and settings don’t get added to the command list according to reasoning that is hidden from us mere customers.

To add a ‘missing’ option to a ribbon or Quick Access Toolbar you have to first create a short VBA function and to make that function you need the right VBA command.

All Office features should be available via VBA methods or properties. You can find the VBA equivalent of a command or setting using the Record Macro feature. In short, turn on Remove Macro, do the thing or change the setting you want, turn off macro recording then look at the macro to see the VBA version of your actions.

For example, several readers have pointed to the Keep Track of Formatting setting under Word Options | Advanced | Editing. It’s not listed in the customize command list.

From the recorded macro you’d find that the true/false setting is:

Options.FormatScanning 
 

Turn that into a macro which reverses the current setting:

Sub FormatScanningToggle()
 Options.FormatScanning = Not Options.FormatScanning
 End Sub
 

Or a macro to make sure the setting is on:

Sub FormatScanningOn()
Options.FormatScanning = True
End Sub

 

Now when you go to the Customize Ribbon or Quick Access Toolbar dialog in Office you’ll find your macro under the Macros list. You can add the macro as a button on the QAT or a ribbon.

Office - Macro command list image from Adding to the Customize Command List at Office-Watch.com

In this case the command is stored in the Normal template and available to all documents on that computer.

Article posted: Thursday, 05 May 2011

there's more ...

If you liked this article you'll LOVE our new ebooks.

Office 2013: the real startup guide

OFFICE 2013: the real startup guide Everything you need to know about Office 2013 but Microsoft won't tell you.

How to save money, install, configure and use the new features in Office 2013.  Get it today - click here.

Windows 8 for Microsoft Office users

Windows 8 for Microsoft Office users A practical guide the new, changed and unfamiliar in Windows 8

A focused and unvarnished look at Windows 8, especially written for the many people who use Microsoft Office  Get it today - click here.

ORGANIZING OUTLOOK EMAIL - tame your Outlook 2010 Inbox

100+ pages of practical tips and help to streamline, automate and search your Inbox.  Get more than you ever thought possible from Outlook.  Read it today - click here.

More from Office Watch:



Article Services sponsored by: Office Watch Ebooks - available now to download and read today.
RSS feed for this category Subscribe

Translate | Mobile | Links
 Add to: Bookmarks | | DiggThis | Yahoo! My Web


New & Popular
» Simple and useful PivotTables
» Microsoft’s commitment to Office beyond Windows
» Which character code is that?
» How Word’s grammar check can let you down
» One Terabyte of OneDrive is here
» What is Microsoft Delve?


Office Watch, Office for Mere Mortals, Access Watch and all titles used within the publications are Copyright © 1996-2014 Office Watch.
Microsoft Office, Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft Powerpoint and doubtless many other names are registered trademarks of Microsoft Corporation.

Search  |  Sitemap |  Popular Topics | Privacy Statement |  Advertising |  Twitter |  Feedback / Contact Us
Office Watch is definitely not affiliated with Microsoft - and that's just one reason why we are so useful to Microsoft Office users around the world J (Erko).