Traditional Culture Encyclopedia - Photography and portraiture - 2007ExceL has set a macro in 2007, but when running the macro, it always prompts that the macro has been disabled according to the macro security settings, and then I modified the macro settings.

2007ExceL has set a macro in 2007, but when running the macro, it always prompts that the macro has been disabled according to the macro security settings, and then I modified the macro settings.

Excel2007 sets macro security here:

Click the office icon in the upper left corner-> Click the Excel option at the bottom-> Click the Trust Center on the left-> Click Trust Center Settings on the right-> Click macro settings on the left-> Select the security level you want on the right.

Usually, the second option is to disable all macros and publish notifications. This way, after seeing the notification, you can still manually enable macros in the current workbook.

Good luck!