Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 01-14-2020, 03:06 PM
thomasoj thomasoj is offline VBA - change font and font size for Word footnote Windows 10 VBA - change font and font size for Word footnote Office 2016
Novice
VBA - change font and font size for Word footnote
 
Join Date: Jan 2020
Posts: 3
thomasoj is on a distinguished road
Default VBA - change font and font size for Word footnote

Hello,
Thank you in advance for your assistance. I produce outgoing letters that obtain information from multiple resources. The resources are created by different individuals and they use different styles and formatting.


I was able to solve changing the body of the letter to a consistent font and font size. My problem is with the footnotes. I thought I would just have to change the range in my other macro to footnotes and I'd be set. Unfortunately, I was incorrect.
Here is what I have written. (I'm very new to VBA and programming)


Sub Zchangefootnote()
'
' Zchangefootnote Macro
'
Dim intResult As Integer
Dim strMessage As String
Dim myRange As Range
Set myRange = ActiveDocument.footnotes
myRange.WholeStory
myRange.Font.Name = "Times New Roman"
myRange.Font.Size = 10


Exit Sub
End Sub


The error occurs at Set myRange = Activedocument.footnotes.


Thank you for any assistance.


Tom
  #2  
Old 01-15-2020, 02:37 AM
macropod's Avatar
macropod macropod is offline VBA - change font and font size for Word footnote Windows 7 64bit VBA - change font and font size for Word footnote Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

This thread is a duplicate of: https://www.msofficeforums.com/word-...-footnote.html
Kindly don't start multiple threads on the same topic. Thread closed. You may continue the discussion in your other thread.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA - change font and font size for Word footnote Merging two Word documents: 2nd document not maintaining original font type and font size Swarup Word 31 08-28-2018 06:55 PM
Opening doc in Word 2010 causes normal template to change - font size incorrect Simonb Word 4 01-26-2016 03:52 PM
VBA - change font and font size for Word footnote How to change the font of footnote numbering? mudum Word 2 12-03-2015 06:27 AM
VBA - change font and font size for Word footnote Looping Macro to Change Font, Font Size, and Give Heading 1 WH7262 Word VBA 1 08-26-2014 03:46 PM
Word will not hold settings, such as font and size of font Mary M Word 1 10-12-2013 07:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:58 PM.


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