Forum

Notifications
Clear all

issue with Macro

3 Posts
2 Users
0 Reactions
97 Views
(@ayemu7)
Posts: 197
Reputable Member
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.

ExcelMacro.PNG

 
Posted : 11/08/2021 3:58 am
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

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
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

many thanks, Phil.

All good now.

Regards,

Aye

 
Posted : 13/08/2021 5:22 am
Share: