View Single Post
 
Old 11-07-2015, 12:49 PM
Words Words is offline Windows XP 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