View Single Post
 
Old 11-28-2016, 08:54 AM
derekcentrico derekcentrico is offline Windows 7 Office 2010 (Version 14.0)
Novice
 
Join Date: Jul 2010
Posts: 6
derekcentrico is on a distinguished road
Default Newb needing VBA solution to change formatting

I'm totally ignorant to this stuff so please forgive me in advance.

I made a quick form that uses bookmarks to copy the data to the various pages. However, I've run into a few hiccups doing so with the font color and font type.

What could I add to this command that will change the font to Arial and the font color to black? I'd like it to the the whole body and headers/footers if possible.

Current bookmark removing VBA found on another website:
Code:
Sub removebookmarks()
Dim bkm As Bookmark
For Each bkm In ActiveDocument.Bookmarks
bkm.Delete
Next bkm
End Sub
I tried this combo and it didn't work.

Code:
Sub removebookmarks()
Dim bkm As Bookmark
For Each bkm In ActiveDocument.Bookmarks
bkm.Delete
Next bkm
End Sub
ActiveDocument.Font.ColorIndex = wdBlack
With ActiveDocument.Font 
 .Name = "Arial" 
End With
Any help is appreciated.
Reply With Quote