How to unblock macros enable excel file

Question

Hello everyone I am using the macro enabled excel file, after check in unblock box in properties.

now this excel is showing this message how can i fix it.

Answer 1

Hello Gaurav,

Thank you for posting your question in our community, please can did you download the file online ? If so please use the steps below:

Tap the start button or Windows key and type Internet Options.

Select Internet Options from the search results and the Internet Properties dialog box will appear.

On the Security tab, select Trusted Sites, then select Sites.

Type the URL of the site or server that contains the Microsoft 365 files with the macros you want to run, and then select Add.

Select Close and then OK.

Please let us know if the issue persists after that.

Best Regards, Asher

Answer 2

Thank you so much for the reply

after following your steps this is still exist.

it is showing in my all excel file.

Answer 3

Hi Gaurav S,

My name is Tim and I’m sorry to see you’re experiencing issues. I will gladly assist you today.

From within Excel:-

Click the File tab.

Click Options.

Click Trust Center, and then click Trust Center Settings.

In the Trust Center, click Macro Settings.

Make the selections that you want, then click OK.

You can find more information regarding the above in a Microsoft Support Document link below:-

https://support.microsoft.com/article/12b036fd-d140-4e74-b45e-16fed1a7e5c6

Give back to the community. Help the next person who has this issue by indicating of this reply solved your problem. Please click Yes or No below.

If you require any further information then please don’t hesitate getting it contact. I will be more than happy to assist you further.

Kind regards

Tim

Answer 4

I've tried these steps for a file I downloaded as part of an online course. I've check the Enable VBA macros and the Enable Excel 4.0 macros when VBA macros are enabled. I've also checked the Trust access to the VBA project object model.

I still have the blocking message and can't get access to the macros/content of the file.

J

Answer 5

If none of these works then do this 100% works.

From within Excel:- Click the File tab. Click Options. Click Trust Center, and then click Trust Center Settings. In the Trust Center, click Trusted Location. Click Add new location, and click Browse. Then select the folder your excel is in. Then click all the "Okay"

Your Welcome