Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-18-2024, 04:14 AM
w64bit w64bit is offline Replace font in Normal Style Windows 10 Replace font in Normal Style Office 2021
Novice
Replace font in Normal Style
 
Join Date: Jan 2015
Posts: 19
w64bit is on a distinguished road
Default Replace font in Normal Style

I tried to change this code to replace the Normal Style font when it's Arial to Calibri, but I cannot make it work.
I am using it with Batch Process Documents 4.9 (Graham Mayor).
Can you please give me a little help?
Thank you
Code:
Function ChangeFont(oDoc As Document) As Boolean
Dim oStory As Range
    On Error GoTo err_Handler
    For Each oStory In oDoc.StoryRanges
        oStory.Font.Name = "Arial"
        If oStory.StoryType <> wdMainTextStory Then
            While Not (oStory.NextStoryRange Is Nothing)
                Set oStory = oStory.NextStoryRange
                oStory.Font.Name = "Calibri"
            Wend
        End If
    Next oStory
    Set oStory = Nothing
    ChangeFont = True
lbl_Exit:
    Exit Function
err_Handler:
    ChangeFont = False
    Resume lbl_Exit
End Function

Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a text style which only changes the font and font size? Jenson Word 3 03-04-2024 02:54 AM
Replace font in Normal Style Check the font attached to a template's "Normal" style and report if it's not installed Matt C Word VBA 3 10-31-2021 05:54 AM
Replace font in Normal Style Replace table and figure caption style to another style Word VBA laith93 Word VBA 7 08-27-2021 11:37 PM
Change Normal Style JohnM Word 2 03-23-2016 07:40 AM
Replace font in Normal Style Outlook2013 Normal Style sus4n Outlook 3 08-07-2014 06:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft