Notifications
Clear all
Topic starter
Hi Team,
I have an excel report with macro enabled. I tried to open that and came across the following message. I tried enabling macro and search for help. But no luck.
Please let me know other area I should check.
Thank you.
Posted : 11/08/2021 3:58 am
Hi,
When you open a workbook containing macros you should get a default warning towards the top of the screen (under the Ribbon) asking you if you want to enable macros. Say yes.
In case you have macro security set to be disabled without notification. you'll need to go into
File -> Options -> Trust Center -> Macro Settings
and set them to 'Disable VBA macros with notification'
Regards
Phil
Posted : 12/08/2021 2:33 am
Topic starter
many thanks, Phil.
All good now.
Regards,
Aye
Posted : 13/08/2021 5:22 am