Share via

Locked macros

Anonymous
2022-09-06T14:04:26+00:00

I have a file that is saying a Macro is blocked that is potentially dangerous

I have deleted the Macro, but I am still getting the message

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-06T17:06:10+00:00

    Hello William H,

    Hope you are doing great and well today.

    My name is Sarah, I'd be happy to assist you today.

    With regards to your concern above, I will help you to get rid of the error from Locked macros.

    If you know the source of the databases there is one thing that you could try.

    Go into Microsoft Access; Select the File menu; Select Options; Select Trust Center; Select Trusted Locations; Select the Add new location button and all the path to the folder where you store the databases.

    You may also try these simple tricks: Save the file as a .xlsx, close it, then open the .xlsx version - all macro code should be removed from the new file.

    If you have any concern or clarification. Please comment below for more information.

    Best regards,

    Sarah

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-09-06T15:47:31+00:00

    Save the file as a .xlsx, close it, then open the .xlsx version - all macro code should be removed from the new file.

    Was this answer helpful?

    0 comments