DATA DOCTORS

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 how to use AI on your smartphone

If your smartphone is relatively new and updated with the latest operating system, you’re using AI-powered tools without even knowing it.

6 days ago

(Pexels Photo)...

Ken Colburn, Data Doctors

Here are which electronics are OK in checked baggage

The primary determinant of what is safe to check in baggage is today’s most common battery technology: Lithium Ion.

13 days ago

DNS can help Arizonans protect their online security...

Ken Colburn, Data Doctors

How Arizonans can protect their cyber safety through DNS

DNS stands for Domain Name Service. It's is a vital element of Internet infrastructure all Arizonans should know about when working online.

20 days ago

(Pexels Photo)...

Ken Colburn, Data Doctors

Here are some useful Windows keyboard shortcuts

Keyboard shortcuts are one of the most underutilized features of any operating system and Windows 11 has many new ones.

27 days ago

Depending on the size of your home or how far outside your home you want the signal to be usable, r...

Ken Colburn, Data Doctors

Here’s how to choose the best WiFi router location

Depending on the size of your home or how far outside your home you want the signal to be usable - for items like security cameras - router placement is critical.

1 month ago

Which smart phone is right for you? (Photo by Jaap Arriens/NurPhoto via Getty Images)...

Ken Colburn, Data Doctors

Tips for buying smartphones: A used edition could be right for you

The yearly improvement in smartphone technology leads many people to get rid of perfectly good smartphones for the ‘latest and greatest.'

2 months ago

Sponsored Articles

...

Collins Comfort Masters

Here’s 1 way to ensure your family is drinking safe water

Water is maybe one of the most important resources in our lives, and especially if you have kids, you want them to have access to safe water.

(KTAR News Graphic)...

Boys & Girls Clubs

KTAR launches online holiday auction benefitting Boys & Girls Clubs of the Valley

KTAR is teaming up with The Boys & Girls Clubs of the Valley for a holiday auction benefitting thousands of Valley kids.

...

Canvas Annuity

Interest rates may have peaked. Should you buy a CD, high-yield savings account, or a fixed annuity?

Interest rates are the highest they’ve been in decades, and it looks like the Fed has paused hikes. This may be the best time to lock in rates for long-term, low-risk financial products like fixed annuities.

Here’s how to use macros safely and effectively