by Allen Wyatt
(last updated July 16, 2018)
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
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, and 2013.
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!
Fonts, by default, come with one or more styles that define variations of how that font is displayed in your document. ...Discover More
When you make extensive edits to a document and those edits include changing the formatting of numbered or bulleted ...Discover More
Sometimes Word does things that just don't make sense. For instance, have you ever inserted a section break into your ...Discover More
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
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.