Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, and 2013. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Printing a List of Custom Styles.

Printing a List of Custom Styles

by Allen Wyatt
(last updated February 14, 2015)

1

Word allows you to create styles to define how the text in your document should appear. Besides a full list of built-in styles, Word allows you to create any custom styles that you may desire. You can later print a style sheet for your document, as described in other issues of WordTips.

What if you want a list of only custom styles, however? Word doesn't include a feature that allows you to discriminate on which styles are included in a style sheet printout. If you want a list of custom styles used in a document, you can create one by using a macro. The following macro steps through all the styles and compiles a list of those that meet both criteria (custom and being used):you can also read the ActivePrinter property

Sub PrintCustomStyles()
    Dim docThis As Document
    Dim styItem As Style
    Dim sUserDef(499) As String
    Dim iStyleCount As Integer
    Dim J As Integer

    ' Ref the active document
    Set docThis = ActiveDocument

    iStyleCount = 0
    For Each styItem In docThis.Styles
        'see if being used
        If styItem.InUse Then
            'make sure not built in
            If Not styItem.BuiltIn Then
                iStyleCount = iStyleCount + 1
                sUserDef(iStyleCount) = styItem.NameLocal
            End If
        End If
    Next styItem

    If iStyleCount > 0 Then
        ' Create the output document
        Documents.Add

        Selection.TypeText "User-defined Styles In Use"
        Selection.TypeParagraph
        For J = 1 To iStyleCount
            Selection.TypeText sUserDef(J)
            Selection.TypeParagraph
        Next J
        Selection.TypeParagraph
        Selection.TypeParagraph
    Else
        MsgBox "No custom styles in use."
    End If
End Sub

Remember that there is a difference between "custom styles" and "customized styles." (A built-in style can be a customized style, if you change the default characteristics of the style.) This macro prints a list of custom styles; it completely ignores those styles that Word considers built-in.

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (8339) applies to Microsoft Word 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Word here: Printing a List of Custom Styles.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Calculating the Day of the Year

Need to know what day of the year a certain date is? You can figure it out easily using the formulas in this tip.

Discover More

Monday's Date on Friday's Report

Automatically putting today's date at the top of a report is easy. Putting a different date, automatically, can be more ...

Discover More

Losing Data in a Shared Workbook

When you create a shared workbook, you run the risk of losing some of the data in that workbook. Here's a discussion ...

Discover More

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!

More WordTips (ribbon)

Deleting Styles

As documents evolve, so do your needs for various styles. You may create new ones and, invariably, old ones need to be ...

Discover More

Can't Select Style Instances

Using the Styles and Formatting task pane, Word allows you to select all instances of a given style in your document. ...

Discover More

Viewing Your Custom Styles

If you develop a set of preferred styles, you may want to use those styles with a document you receive from someone else. ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five more than 3?

2015-03-19 08:06:23

PS

macro fails at:

sUserDef(iStyleCount) = styItem.NameLocal


This Site

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.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.