Page 22 of 32PREVNEXT

Help secure and protect data in Excel

Macro in Visual Basic window

A macro can quickly run a sequence of steps and commands that otherwise could be time consuming.

You've heard about macros, but what are they?

A macro is a sequence of commands that can be run automatically. It is very useful for running a repetitive set of steps automatically. For example, a macro program can be used to automate a series of routines such as spell checking, or to count the number of cells that are filled in on a worksheet. Office programs have macros in them that you might never have noticed.

Why do you need to worry about macros?

Unfortunately, anyone can write a macro that includes a harmful sequence of commands. Harmful commands could do something simple such as add or remove text in a document, or even remove data from your computer.

The good news is that you can set up Excel to detect macros. Go on to the next lesson to find out more about protecting your computer.

Page 22 of 32PREVNEXT