Macro security settings in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Macro Security Levels

Which macro security setting in Excel will allow macros to run only if they are digitally signed by a trusted publisher?

A Enable all macros (not recommended)

B Disable all macros with notification

C Disable all macros except digitally signed macros

D Disable all macros without notification

💡 Hint

Think about which setting allows only trusted macros to run.

The setting 'Disable all macros except digitally signed macros' allows macros to run only if they have a valid digital signature from a trusted publisher, enhancing security.

🎯 Scenario

intermediate

Choosing Macro Security for a Shared Workbook

You share an Excel workbook with colleagues who often enable macros. To protect against malicious code but allow trusted macros, which security setting should you recommend?

A Disable all macros without notification

B Disable all macros except digitally signed macros

C Disable all macros with notification

D Enable all macros (not recommended)

💡 Hint

Consider a balance between security and usability.

Disabling all macros except digitally signed macros allows trusted macros to run while blocking potentially harmful unsigned macros, which is ideal for shared workbooks.

📊 Formula Result

advanced

Macro Security Setting Impact on Macro Execution

If the macro security is set to 'Disable all macros with notification' and a workbook contains an unsigned macro, what will happen when the workbook is opened?

A A security warning appears allowing the user to enable the macro.

B The macro is disabled and no notification is shown.

C The macro runs automatically without any warning.

D The macro runs only if the workbook is saved in a trusted location.

💡 Hint

Think about user control and warnings.

With 'Disable all macros with notification', Excel disables macros but shows a warning so the user can choose to enable them if they trust the source.

❓ Function Choice

advanced

Identifying the Trusted Location Feature

Which Excel feature allows macros to run without security warnings when the workbook is stored in a specific folder?

A Macro Settings: Enable all macros

B Digital Signatures

C Protected View

D Trusted Locations

💡 Hint

This feature lets you mark folders as safe for macros.

Trusted Locations are folders designated by the user or admin where Excel allows macros to run without warnings, improving workflow while maintaining security elsewhere.

❓ data_analysis

expert

Analyzing Macro Security Settings Impact on Workbook Behavior

Given these macro security settings and workbook states, which combination will allow an unsigned macro to run without any prompt or warning? 1) Macro Security: Disable all macros except digitally signed macros 2) Macro Security: Disable all macros with notification 3) Workbook stored in a Trusted Location 4) Workbook not stored in a Trusted Location Choose the correct combination:

A Setting 2 with Workbook 3

B Setting 2 with Workbook 4

C Setting 1 with Workbook 4

D Setting 1 with Workbook 3

💡 Hint

Trusted Locations can override some macro restrictions.

When macro security is 'Disable all macros with notification' and the workbook is in a Trusted Location, macros run without prompts. Other combinations either block unsigned macros or show warnings.