Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-28-2016, 08:54 AM
derekcentrico derekcentrico is offline Newb needing VBA solution to change formatting Windows 7 Newb needing VBA solution to change formatting Office 2010 (Version 14.0)
Novice
Newb needing VBA solution to change formatting
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newb needing VBA solution to change formatting newb - search and replace - WILDCARDS - keep original...? Bansaw Word 4 09-01-2016 11:16 AM
Backing up importing & exporting ?? I am a newb Jazz OneNote 0 01-27-2016 10:18 PM
Newb needing VBA solution to change formatting newb - need help automating catalogue production Deeper Office 2 09-09-2015 01:45 AM
Newb needing VBA solution to change formatting Is there a solution to change the recentfilelist programmatically dherr Excel Programming 13 12-02-2014 08:31 AM
NEWB to Macros - formatting exports EC37 Excel Programming 52 06-25-2014 06:26 AM

Other Forums: Access Forums

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