Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2019, 11:06 AM
Chuck Barnett Chuck Barnett is offline create macro to change font size to 12.5pt Windows 10 create macro to change font size to 12.5pt Office 2019
Novice
create macro to change font size to 12.5pt
 
Join Date: Feb 2019
Posts: 4
Chuck Barnett is on a distinguished road
Default create macro to change font size to 12.5pt

I tried to do this but it seems Word didn't like that and changed it to 12pt. Is this not a doable function?

Alternatively, if I knew how, I would change the normal template so that every new document came with Calibri 12.5 single spaced with no spacing before or after paragraphs.

Not that skilled and too impatient to study lengthy documentation...

Thanks!



Chuck
Reply With Quote
  #2  
Old 02-27-2019, 11:31 AM
Charles Kenyon Charles Kenyon is offline create macro to change font size to 12.5pt Windows 10 create macro to change font size to 12.5pt Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Chuck Barnett View Post
I tried to do this but it seems Word didn't like that and changed it to 12pt. Is this not a doable function?

Alternatively, if I knew how, I would change the normal template so that every new document came with Calibri 12.5 single spaced with no spacing before or after paragraphs.

Not that skilled and too impatient to study lengthy documentation...

Thanks!

Chuck

Chuck, ignorance is curable, but there is no pill.

Yes. This is something that can be done.
To get 12.5 you cannot select it from the drop-down, but you can type in 12.5 and it will be the font size used.


The following will do what you want but is not a good idea!
  1. Open the Normal template.
    How to Open the Normal Template
  2. Right-Click on the normal style and modify it. Change the font as you want.
  3. Change the line spacing in paragraph formatting to meet what you want.
  4. OK the style change.
  5. Save and close the normal template.
You will likely be unhappy with the result. You might be happier with WordPad. It is much simpler.

Word is a very complex program with a deceptively easy interface. For most documents it is very easy to use. If it is a tool you use, you owe it to yourself to learn how to make it do what you want. Anything else dooms you to frustration.

Some suggested reading to help cure ignorance:
None of these are short. The shortest are the series of tutorials by Shauna Kelly. The last two are much longer.
Reply With Quote
  #3  
Old 02-27-2019, 11:53 AM
kilroy kilroy is offline create macro to change font size to 12.5pt Windows 10 create macro to change font size to 12.5pt Office 2016
Competent Performer
 
Join Date: Sep 2016
Location: Southern Ontario
Posts: 118
kilroy is on a distinguished road
Default

I don't know what your macro is but this macro works for me.

Code:
Sub calibrifont1()
ActiveDocument.range.Font.Name = "Calibri"
ActiveDocument.range.Font.Size = 12.5
lbl_Exit:
Exit Sub
End Sub
Reply With Quote
  #4  
Old 02-27-2019, 01:33 PM
macropod's Avatar
macropod macropod is offline create macro to change font size to 12.5pt Windows 7 64bit create macro to change font size to 12.5pt Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes, but using such a macro is a particularly poor way of trying to solve the problem as it doesn't address the underlying issue.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 02-27-2019, 05:00 PM
Chuck Barnett Chuck Barnett is offline create macro to change font size to 12.5pt Windows 10 create macro to change font size to 12.5pt Office 2019
Novice
create macro to change font size to 12.5pt
 
Join Date: Feb 2019
Posts: 4
Chuck Barnett is on a distinguished road
Default

Thank you, all!

Charles I followed your instructions to modify the normal style successfully.

I am curious what you meant by saying I'd likely not like the result. It seems to work perfectly well.

Thanks, again!

Chuck
Reply With Quote
  #6  
Old 02-28-2019, 07:30 AM
Charles Kenyon Charles Kenyon is offline create macro to change font size to 12.5pt Windows 10 create macro to change font size to 12.5pt Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

The normal style does not control everything in a document, it is the most central, though. For example, line spacing for the Heading styles will be different and should be.

I strongly urge you to review the short series of tutorials that starts with:

You will be a lot happier working with Word if you do.
Here are some other things to look at:
Reply With Quote
Reply

Tags
font size, macro, normal.dot



Similar Threads
Thread Thread Starter Forum Replies Last Post
create macro to change font size to 12.5pt Looping Macro to Change Font, Font Size, and Give Heading 1 WH7262 Word VBA 1 08-26-2014 03:46 PM
create macro to change font size to 12.5pt Change in font size of docproperty Sandy27 Word 9 01-03-2014 01:51 PM
Unable to change font size Andoheb Outlook 1 11-23-2012 07:24 PM
create macro to change font size to 12.5pt how change size font to inches size kkepo Word 4 08-28-2012 08:53 PM
create macro to change font size to 12.5pt Change font & point size? markg2 Outlook 2 06-09-2010 03:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:31 AM.


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