Microsoft Office Tutorials and References
In Depth Information
The Excel default macro security level is Disable All Macros With Notification, which means
that Excel displays a warning on the Message Bar but allows you to enable the macros
manually. Selecting the Disable All Macros Without Notification option does exactly what the
label says. If Consolidated Messenger’s company policy is to disallow all macros in all Excel
workbooks, its employees would select the Disable All Macros Without Notification option.
Important Because it is possible to write macros that act as viruses, potentially causing harm
to your computer and spreading copies of themselves to other computers, you should never
choose the Enable All Macros security setting, even if you have virus-checking software
installed on your computer.
The best way to get an idea of how macros work is to examine an existing macro. To do
that, display the View tab. In the Macros group, click the Macros button, and then click
Tip In the Macro dialog box, you can display the macros available in other workbooks by
clicking the Macros In box and selecting a workbook by name or selecting All Open Workbooks
to display every macro in any open workbook. If you select either of those choices, the macro
names that are displayed include the name of the workbook in which the macro is stored.
Clicking This Workbook displays the macros in the active workbook.
The Macro dialog box displays a list of macros in your workbook. To view the code behind
a macro, you click the macro’s name and then click Edit to open the Visual Basic Editor.