unable to enable the macro settings

Hi Sehaj Deol,

Welcome to Microsoft Community. Thank you for reaching out.
Based on your description, I could understand that macros are being blocked due to security settings in Microsoft Office, even though you've enabled them in the Trust Center.

You can try those steps below:

• Unblock the file: Right-click the file, go to Properties, and check the “Unblock” box under the General tab.
• Add a Trusted Location: In Excel or Access, go to File > Options > Trust Center > Trusted Locations, and add the folder where your file is saved.
• Enable macros: In Trust Center > Macro Settings, choose “Enable all macros” or “Enable all macros with notification.”
• Check for admin restrictions: If your device is managed by an organization, macro settings may be restricted by policy. Please contact your IT administrator if needed.

Note: Please understand that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.     

Your detailed response will help us diagnose and investigate the issue more efficiently.
If I misunderstood what you’re looking for, feel free to let me know or share a screenshot. I’d be happy to help further!

Thank you for your cooperation.
Best regards,

Alex - MSFT | Microsoft Community Support Specialist

Did you add a Trusted Location?

Firstly, you mention worksheet, so I'm assuming you are referring to Excel. This forum is for discussing Microsoft Access Databases. Your be best to ask Excel questions in an excel specific forum.

That's said, your current issue is office related, so we might still be able to guide you.

I believe this is related to Microsoft's Macro Blocking. Review the following as it has all the information and a video on the matter:

https://www.devhut.net/bypassing-microsofts-new-blocking-of-macros-vba-code/

Hi, If you still have further concerns, please feel free to let us know.