Here’s how to use macros safely and effectively

Jan 13, 2024, 7:15 AM

(Pexels photo)...

(Pexels photo)

(Pexels photo)

Q: What are ‘macros’ and how are they used?

A: In the world of computer software, macros are powerful tools available in programs you likely use every day.

They essentially provide you with the ability to create a set of instructions that can be grouped and launched with a simple combination of keys.

Creating a macro is the process of recording keystrokes and mouse clicks for repetitive tasks such as creating tables, custom layouts or inserting formulas and cell widths in a spreadsheet.

Productivity applications such as Word and Excel are where most people find macros to be useful.

A Word of Warning

Before using macros, you’ll want to make sure the security settings in both Word and Excel are set not to run macros automatically.

In the early days, any macro that was embedded in a document or spreadsheet could automatically run when the file was opened, which led to malicious use of the tool.

Hackers started sending rigged documents as attachments in emails with what appeared to be important information that should be read immediately.

Imagine getting an email that claimed to be from the HR department of your company with the announcement of layoffs that included a document explaining the termination process.

Anyone who fell for these types of scams would have been compromised by the malicious macro hiding in the document, which is why they should be disabled by default.

Enable Macros Safely

Microsoft has implemented a security feature that blocks macros from running when they come from the Internet which generates a warning message: “SECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted.”

Despite this protection, you’ll still want to check how your programs handle macros to make sure they are set to a safe option.

It should be set to allow you to enable macros on a case-by-case basis, mainly for the macros in documents that you create.

In Word, click on File, then on Options (at the bottom left), then on Trust Center (bottom left), then on the ‘Trust Center Settings’ button to see your current Macro Settings.

Make sure it’s set to ‘Disable all macros with notification.’

The process for Excel is slightly different: File > Options > Trust Center > Trust Center Settings > Macro Settings.

Excel uses Visual Basic Application (VBA) for its macros, which makes them more powerful and more dangerous.

Make sure it’s set to ‘Disable VBA macros with notification’ so you have the same case-by-case option to enable them.

Creating a Macro

To create a macro in Word or Excel, click on the ‘View’ menu, then on the down arrow below the Macros icon, then on Record Macro to open the ‘Record Macro’ dialogue box.

This is where you will give your macro a name and in Word, choose whether you want to assign it to a button or a keyboard combination (Excel uses keyboard shortcuts).

The detailed instructions on all versions of Word are posted here and for Excel here.

Advanced Options

If you’d like to use macros in just about anything you do on your computer,  check out tools such as AutoHotkey for Windows or the built-in Automator for Mac users.

Data Doctors

(Pexels Photo)...

Ken Colburn, Data Doctors

Here’s why you should use Gmail’s unsubscribe tool

Many 3rd party tools offer to help, but in virtually every case, it requires giving up some privacy, so using Gmail’s built-in option is my current preference.

4 days ago

(Pexels Photo)...

Ken Colburn, Data Doctors

Here are your options for resetting your forgotten passwords

If a forgotten password is easily reset, it’s not much of a security barrier, which is why resetting can get complicated.

11 days ago

Several plugs are seen attached to a power strip surge protector....

Data Doctors

Here’s what you need to know before buying a power strip to protect multiple devices

If you are looking for a power strip to protect a large number of devices, here's what you need to know before buying one.

19 days ago

Find something you downloaded: Steps for Android, iOS...

Ken Colburn, Data Doctors

Arizonans: Can’t find something you downloaded to your smartphone a while ago? Try this

Want to find something you downloaded to your smartphone? Files can be easy to use. Follow these steps for Androids and iOS.

25 days ago

Moving your Cox email to Yahoo Mail? Learn about the transition process, from webmail access to ema...

Data Doctors

Data doctors: Beware of Cox to Yahoo email transition scams

Moving your Cox email to Yahoo Mail? Learn about the transition process, from webmail access to email client settings.

1 month ago

How to sync smartphones to Windows computers: Arizona tips...

Data Doctors

Tech tip for Arizonans: How to sync smartphones to Windows computers

Want to learn how to sync smartphones to Windows computers? This article from the Data Doctors explains which steps to take.

1 month ago

Sponsored Articles


Sanderson Ford

3 new rides for 3 new road trips in Arizona

It's time for the Sanderson Ford Memorial Day sale with the Mighty Fine 69 Anniversary, as Sanderson Ford turned 69 years old in May.


Day & Night Air Conditioning, Heating and Plumbing

Beat the heat, ensure your AC unit is summer-ready

With temperatures starting to rise across the Valley, now is a great time to be sure your AC unit is ready to withstand the sweltering summer heat.



Here are 5 things Arizona residents need to know about their HVAC system

It's warming back up in the Valley, which means it's time to think about your air conditioning system's preparedness for summer.

Here’s how to use macros safely and effectively