Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-05-2024, 01:49 AM
Shelley Lou Shelley Lou is offline VBA Footnote Issues Windows 10 VBA Footnote Issues Office 2016
Expert
VBA Footnote Issues
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default VBA Footnote Issues

Hi Macropod, thank you for the code, unfortunately, I couldn't get it to work using Ctrl Alt F.

Hi Greg, thank you for the code, I really appreciate it. I have added .Characters(1).Font.Size = 8 to bring the font size down from 10 to 8 and it seems to be working as I wanted it to without changing the actual style in the styles pane. Thank you so much.
Reply With Quote
  #2  
Old 11-05-2024, 04:06 AM
macropod's Avatar
macropod macropod is offline VBA Footnote Issues Windows 10 VBA Footnote Issues Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,523
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

Quote:
Originally Posted by Shelley Lou View Post
Hi Macropod, thank you for the code, unfortunately, I couldn't get it to work using Ctrl Alt F.
Well, you didn't ask for that. To achieve that, all you need to do is add 'Now' to the macro's name.

Whilst you might be happy with Greg's code, do be aware that it will lead to an unnecessary increase in file size compared to the once-off Style modifications. And, if you made those once-off Style modifications in Word's Normal Template, you'd likely never need to bother with them again. Plus, your documents will be less prone to corruption if you modify the Styles than if you use Greg's brute-force approach to modifying each footnote's formatting.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-05-2024, 09:55 AM
Shelley Lou Shelley Lou is offline VBA Footnote Issues Windows 10 VBA Footnote Issues Office 2016
Expert
VBA Footnote Issues
 
Join Date: Dec 2020
Posts: 259
Shelley Lou is on a distinguished road
Default VBA Footnote Issues

Thank you Macropod for pointing out any issues that may arise with the other code, as it may become an issue on our larger 200 page documents with hundreds of footnotes within them.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Footnote Issues How to remove extra space between footnote separator and 1st footnote. No para breaks present. Swarup Word 2 07-09-2022 07:42 PM
VBA Footnote Issues Macro to change font size of Footnote Reference in Footnote Text TheBigBoss Word VBA 5 06-10-2022 06:14 AM
VBA Footnote Issues Footnote references in the footnote section losing their style when cut+pasted from same doc emblaw Word 4 12-08-2020 06:23 AM
VBA Footnote Issues Removing line break and indentation between footnote number and footnote text in Word jaanross Word 5 02-06-2020 12:04 AM
VBA Footnote Issues Adding footnote number as part of footnote text NoCalScribe Word VBA 3 07-15-2019 07:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 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