Opening Workbooks Containing Macros

Whenever you open a workbook that contains macros, Excel displays a warning message, as shown in Figure 1-16. To prevent Excel from displaying this message, you can turn off the virus protection using the Security dialog box (Figure 1-17).

When the virus message comes up, you can select:

■ Disable Macros—Click this button if you are opening a workbook from an unfamiliar source, such as an Internet site or an e-mail, and you want to protect your computer from any macro viruses that may be in the workbook. The workbook will be opened without running any

Figure 1-16:

If the virus protection is turned on, Excel displays a warning message when the workbook contains macros.

auto-macros it may contain. You will then be able to switch to the Visual Basic Editor and review the macros if they are not password protected. After checking the macros, you can close the workbook and then reopen it with macros enabled.

■ Enable Macros—If you know that the workbook comes from a trusted source and contains useful macros, click the Enable Macros button.

■ More Info—Click this button if you need more information before you decide whether to open the workbook with the macros enabled or disabled.

Microsoft Excel 2002 has a useful feature that allows you to automatically disable all macros that are not signed and sent from a trusted source. To access this feature, choose Tools | Macro | Security.

Figure 1-16:

If the virus protection is turned on, Excel displays a warning message when the workbook contains macros.

Figure 1-17:

Selecting the Medium option button will allow you to choose whether to run or not to run macros upon opening a workbook.

Figure 1-17:

Selecting the Medium option button will allow you to choose whether to run or not to run macros upon opening a workbook.

When you create macros that you want to distribute to others, you can use the Digital Signature feature available in the Visual Basic Editor's Tools menu to confirm that the macro does not introduce a virus.

A digital signature on a macro is similar to a handwritten signature on a printed letter. Search the Microsoft Excel online help for information on how to install and create your own digital signature. To access related topics, type "digital signature" in the Answer Wizard.

0 0

Post a comment