Security levels

On more recent versions of Excel, such as XP, you will find that you can assign security levels for accepting macros when opening Excel files. This means that if a file includes a macro from a non-trusted source, then macros will be disabled. To assign a security choose: Tools > Macro > Security... from whence a dialog box will appear as shown in Figure 2.20. Notice that you can set three levels of security:

♦ High - only signed macros from trusted sources accepted, all other macros are disabled.

♦ Medium - user can choose whether to run potentially unsafe macros. This is the default level.

♦ Low - all macros accepted. Use only if you are confident all macros are safe, or unless you have macro antivirus software installed.

Figure 2.20 Setting security levels

Figure 2.20 Setting security levels

0 0

Post a comment