Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-07-2015, 12:49 PM
Words Words is offline Font change changes formatting - please help! Windows XP Font change changes formatting - please help! Office v. X
Explorer
 
Join Date: Dec 2012
Posts: 13
Words is on a distinguished road
Default Macro for changing font without changing formatting

This works for me and is invaluable. Create a macro thus; mine is named Ar10chg because I use it to change everything to Arial 10. All the font sizes, underscores, bold, italic, and font colors are unchanged, but everything becomes Arial 10. Be sure to create a backup first!

Sub Ar10chg()
'
' Ar10chg Macro
' Macro recorded 11/7/2015 by Administrator

Selection.WholeStory
With Selection.Font
.Name = "Arial"
.Size = 10
End With
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Font change changes formatting - please help! Looping Macro to Change Font, Font Size, and Give Heading 1 WH7262 Word VBA 1 08-26-2014 03:46 PM
Formatting font MTWord Word 1 11-03-2013 04:08 PM
if letter change font also change gsrikanth Excel 1 05-15-2012 03:03 AM
Font change changes formatting - please help! Make Font Dropdown Change All Styles' Font trevorhiller Word 1 04-14-2012 02:14 AM
Change font across company Dill Excel 1 11-04-2009 08:21 PM

Other Forums: Access Forums

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


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