How to Use Macros in Office 2016

How to Use Macros in Office 2016

You might have heard about Macro!

Microsoft Office 2016 or the previous versions have many needed and awesome options like Macro which are not very popular but having different and many usages in our daily task with MS Office. So here I am going tell you that what actually macro is, and how to use it.

Def: Macro in MS Office

Think of a baby who copies your actions or doings. Macro is nearly same like a baby, it copies the task you do inside MS Office or in other words Macro follows the way you do a task, learn and can repeat that. Macros almost does same thing inside different MS Office Programs such as: Project, Visio, Word, Excel, Access, PowerPoint, Publisher and etc, situated Macro is on the View tab, Macro group and Developer tab, Code group.

How to use Macros in Office 2016:

We know that macro does the same in all Office programs so, we will have some examples with MS Word and Excel.

Macro in MS Word:

Let’s try:

  • Navigate to VIEW tab and MACRO group in MS Word.
  • Click on the dropdown below the word “Macros” and Select “Record Macro…”
    1. Give a name (Should not contain space character)
    2. You can assign a button
    3. Assign a shortcut key. We will go with this one, click on the “Keyboard”.

 

Record Macro Office 2016

  • Assign a Keyboard shortcut key!
    1. Select a shortcut key
    2. Click “Assign”
    3. Assigned shortcut keys display here!

Assign Keyboard Shortcut for Macro

  • When you assigned the shortcut key, click close and press “OK” the Macro Dialog Box.
  • Now macro is recording your actions, if a stop button is available on the status bar below the MS word Window.
  • Write something on the page, or do something else with texts like formatting or giving styles then press the “Stop” button on the status bar or on the VIEW tab, Macro-dropdown.
  • After the Macro stopped recording, then press the “assigned shortcut key from the keyboard or go to the View tab, Macro group and Macro Button to run the Macro.
  • If you’ve formatted any text during the macro-recording, then you must select some text to format before macro-run.

All done with MS Word Macro, we will put How to use Macro in MS Excel on the next tutorial,  stay tuned with codejow.

Previous Introduction to Variable in CPlusPlus (Declaration & Scope)
Next PHP Tutorials 4: How to Define and Print Variables

About author

Raza Bayani
Raza Bayani 42 posts

<p>Raza Bayani studies BCE (Bachelor in Computer Engineering) in Poly-technical University of Kabul. He is the CEO of CODEJOW group, a web designer, coder and recently a blogger. Raza thinks, he can help others and also boost-up his own programming skills being on codejow.com.</p>

View all posts by this author →

You might also like