Style Report

Home Up Odds & Ends Photo Gallery Search Contact Me

 

 

 The information in this website is provided without risk or obligation and free of charge.  However, if you have benefitted from my efforts here and would like to make a contribution to help me continue and maintain this work then any donation will be greatly appreciated. Please click the adjacent button to access PayPal.  Thank you.
 

Fellow Microsoft Word MVP Klaus Linke and I worked together to create a "Style Report."  A Word Add-In for for looping through the style collection and providing an interface so users can "keep" or "delete" the styles used in a document or previously used styles that are not applied to any text.  Following user selections, a report is generated showing user actions and the style status.  

The following graphics provide a representation of some of the user options and the report.

A document can contain certain styles that can not be deleted.  For example, if you ever use a Heading 1 through Heading 9 style in a document, that style can not be deleted even if the text with the heading style is subsequently deleted.  The macro recognizes these "hard" styles and reports accordingly.

I used UserForms to substitute for the rather limited traditional VBA message boxes when building this Add-in.  For more on substituting UserForms for message boxes, see:  Custom VBA Message Box
The Add-In is provided here in a zip file format.  You can download "Style Report" to your Word Templates directory and load it using Tools>Templates and Add-Ins.  For more on Add-Ins and how to load them, see the heading "Organizing Global Templates" at:  Organizing Your Macros

Looking for something else?

Google