Written by Allen Wyatt (last updated December 12, 2020)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and 2021
Sue has the dubious honor of developing and maintaining Word templates used in the development of documentation packages for her company's contracted clients. Many of their authors just don't seem to understand the impact of manual changes outside of the template confines, so Sue started using the Restrict Editing tools (in particular, the Limit Formatting to Permitted Styles option). This helpfully constrains their authors to the permitted styles only and removes manual change options by way of graying out the appropriate tools in the ribbon. Several authors use the Format Painter tool (in an acceptable fashion), but this is one of those tools that is grayed out when the restrictions are applied. Sue wonders if there is any way she can access this tool while maintaining the style restrictions.
There is no way to exempt the Format Painter tool from the editing restrictions that can be imposed by Word. You can, however, attempt to work around the restrictions by creating your own version of the Format Painter tool.
The Format Painter runs the built-in command CopyFormat that executes the code Selection.CopyFormat. If the icon is greyed out, the command itself cannot be run but the code from within the macro can still be executed in a user written macro. Similarly, the Paste Format icon runs the PasteFormat macro that executes the code Selection.PasteFormat.
Therefore, the solution is to create two macros to mimic the commands. The macros can then be placed on the Quick Access Toolbar or in a customized group on the ribbon.
Sub FormatPainterMimic() Selection.CopyFormat End Sub
Sub PasteFormatMimic() Selection.PasteFormat End Sub
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (12990) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and 2021.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
If you want to have a blank page at the end of a document section, you can insert one manually or you can use the ...
Discover MoreThe Find and Replace tool in Word allows you to search for formatting and alter it in your replacement text. What it ...
Discover MoreWord allows you to define your own custom paper sizes. It is possible, though, that those sizes may change on their own. ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments