Share via

How to unblock macros enable excel file

Anonymous
2022-11-04T09:26:46+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

15 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-11-28T21:57:55+00:00

    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

    18 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-01-24T03:27:39+00:00

    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

    12 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-11-05T10:26:59+00:00

    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

    5 people found this answer helpful.
    0 comments
  4. Anonymous
    2022-11-04T10:09:09+00:00

    Thank you so much for the reply

    after following your steps this is still exist.

    it is showing in my all excel file.

    Image

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2022-11-04T10:02:55+00:00

    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

    1 person found this answer helpful.
    0 comments