Microsoft Office Forums repeated formatting with macro in Word

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-13-2016, 04:49 AM
Pompidou Pompidou is offline repeated formatting with macro in Word Windows 7 64bit repeated formatting with macro in Word Office 2010 64bit
Novice
repeated formatting with macro in Word
 
Join Date: Sep 2016
Posts: 4
Pompidou is on a distinguished road
Default repeated formatting with macro in Word

hi all,

I'm new to this all and i'm wondering if this is the right way to go about getting the desired result i'm working to. Am I right that i can use macros to get a set of actions done with one click or button combination?

I'm working with a lot of articles and the formatting is always the same. I select everything, shrink the font 3x, change it to 'Calibri', change the color of everything to 'black, text1, lighter 25%' and finaly change, in the page layout, the margins to moderate.

Can all this be done with one macro linked to a button?
I've yet not achieved much result with messing around with the information i find online, could someone maybe guide me to a good source for this specific thing i want, or can someone help me where i could start looking for basics online?



,any help is much apreciated!
Reply With Quote
  #2  
Old 11-13-2016, 04:59 AM
macropod's Avatar
macropod macropod is offline repeated formatting with macro in Word Windows 7 64bit repeated formatting with macro in Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,610
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You should create a paragraph Style with the required formatting, save that to a suitable template (i.e. one that your documents are based on), then you can simply use Ctrl-A to select the entire document before applying the Style.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 11-13-2016, 05:22 AM
Pompidou Pompidou is offline repeated formatting with macro in Word Windows 7 64bit repeated formatting with macro in Word Office 2010 64bit
Novice
repeated formatting with macro in Word
 
Join Date: Sep 2016
Posts: 4
Pompidou is on a distinguished road
Default

Ah! i was just looking for this in the wrong area, thank you very much!
this is perfect for what i want.

edit;
I've been messing around a bit with this, but i found that these styles don't 'interact' with the current formatting. for example, when some of the text in the article is Italic,
and my style just changes the font and color, the italic text not only changes color and font, but also changes the italic bits back to standard form. Is there any way around this?
Reply With Quote
  #4  
Old 11-13-2016, 01:13 PM
macropod's Avatar
macropod macropod is offline repeated formatting with macro in Word Windows 7 64bit repeated formatting with macro in Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,610
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Did you choose a Paragraph Style, or a Character Style?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 11-13-2016, 04:00 PM
Guessed's Avatar
Guessed Guessed is offline repeated formatting with macro in Word Windows 10 repeated formatting with macro in Word Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,354
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

Paragraph style attributes are often overridden by local direct formatting being applied the text. If you have applied the correct style and the text still doesn't look right, make sure there is no local formatting by selecting and pressing Ctrl-Space and Ctrl-Q

Note that these keyboard shortcuts remove character styles too so you need an alternative command if you wanted to keep character styling.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #6  
Old 11-13-2016, 06:49 PM
macropod's Avatar
macropod macropod is offline repeated formatting with macro in Word Windows 7 64bit repeated formatting with macro in Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,610
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Andrew,

My understanding of
Quote:
Originally Posted by Pompidou View Post
when some of the text in the article is Italic,
and my style just changes the font and color, the italic text not only changes color and font, but also changes the italic bits back to standard form.
is that it's the opposite problem: the font is changing from italics to normal text, which is something one would ordinarily expect with a Character Style, not a paragraph Style (unless the entire paragraph was formatted with italics).
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 11-13-2016, 08:58 PM
Guessed's Avatar
Guessed Guessed is offline repeated formatting with macro in Word Windows 10 repeated formatting with macro in Word Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,354
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

I assumed this was a toggle issue that you see with bold and italic. Applying an italic character style to a paragraph that has an italic paragraph style gives you non-italic text.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #8  
Old 11-14-2016, 10:27 AM
Pompidou Pompidou is offline repeated formatting with macro in Word Windows 7 64bit repeated formatting with macro in Word Office 2010 64bit
Novice
repeated formatting with macro in Word
 
Join Date: Sep 2016
Posts: 4
Pompidou is on a distinguished road
Default

Sorry for my late response and my poor explaining of that problem,
but Macropod was absolutely right, that was the problem. Working now with Character Style is giving me everything I want!

Thank you both very much for your time and clear instructions! I really appreciate that!

P.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to highlight repeated words in word file and extract into excel file aabri Word VBA 1 06-14-2015 07:20 AM
repeated formatting with macro in Word Macro for changing formatting of certain parts of a word McBanjo Word VBA 10 12-18-2014 09:23 PM
repeated formatting with macro in Word Need macro to merge files in Word and preserve formatting Carolin Word VBA 3 12-14-2014 04:01 AM
repeated formatting with macro in Word How to give same hyperlink to repeated word in Word document RAJKUMAR BODDAPATI Word 1 11-12-2014 07:07 AM
Insert Multiple hyperlinks to word repeated in doc - easily synses Word 8 02-24-2012 05:17 AM


All times are GMT -7. The time now is 05:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft