how to run VBA macro in the start of ms word

Question

0.00/5 (No votes)

See more:

Dear Expert,
I have to develope a macro in VBA which should be run when the ms word start, and when new document created or open any existing document. My problem is am not able to place the macro at correct position.
I want to write a macro which will make the font "Arial" default when document will be open or created. I know this facility already given by microsoft but i need to do this for our clients.
Kindly help me.
Regards

Posted 13-Aug-13 18:54pm

R. S. Verma

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sriram Bala · Accepted Answer · 2013-08-13T20:05:00

Solution 1

Hi,

As per my Knowledge you need save the document as Macro enabled word document extension. ( I am using word 2010 so .docm). Press Alt+F11 to navigate to code window then try this below code Save the document. This will help you I think.

Sub activeMacro()
Selection.Font.Name = "Arial"
Selection.Font.Size = 16
End Sub

Thanks.
Sriram.B

Posted 13-Aug-13 20:05pm

Sriram Bala

Comments

Maciej Los 14-Aug-13 3:49am

A4!
I prefer to replace "normal template" than using macro. Please, see my answer.

Maciej Los · Accepted Answer · 2013-08-13T21:48:00

You don't need any code. Create new Normal Template document and send it to your client.
A Template is a document type that creates a copy of itself when you open it. A Normal template opens whenever you start Word, and it includes default styles, AutoText, macros, toolbars, and other customizations that determine the basic look of your document.

Change the Normal template (Normal.dot) [^]
Change the Normal template (Normal.dotm )[^]
Save a Word document as a template[^]

Using macros to set default font is a... bad idea ;(