You must enable macros each time you open a workbook containing macros if the macro security setting is 'Disable all macros with notification.'

Question

Quizplus · Accepted Answer

When the macro security setting is 'Disable all macros with notification,' the user must enable macros each time they open a workbook containing macros. This is because the security setting blocks all macros by default, but prompts the user to enable them upon opening the file.

You Must Enable Macros Each Time You Open a Workbook