Microsoft has blocked macros from running

Anonymous
2022-06-08T03:54:07+00:00

Hello All,

you might know that " Microsoft has blocked Macros from running through internet" do we have any permanent solution on this?

I have tried the below solution which doesn't work.

  1. Save the file to a local hard drive, network share, or cloud share like OneDrive.
  2. Open Windows File Explorer and go to the folder where you saved the file.
  3. Right-click the file and choose Properties from the context menu.
  4. At the bottom of the General tab, you should see a section for Security. Select the Unblock checkbox and select OK.

Also, tried to enable Macros through Macros settings through Trust center but didn't work?

is there any permanent solution on this?

Thanks,

AMit

Microsoft 365 and Office | Excel | For business | 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
Answer accepted by question author
Anonymous
2022-06-17T08:05:21+00:00

Hi,

I think I found a solution to my problem.

The solution is to re-map the network drive to the fileserver name first and then adding that mapped directory to the trusted locations in excel.

Mapped Location:

\fileserver\networkdirectory and not \[192.xxx.xxx.xxx]\networkdirectory

Hope it helps someone out there.

Regards,

Ryno

Was this answer helpful?

100+ people found this answer helpful.
0 comments

112 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. lmacri 2,505 Reputation points
    2022-07-18T14:14:05+00:00

    Users following this thread might find some helpful information in Susan Bradley's 11-Jul-2022 ComputerWorld article Now’s the Time to Prep for Microsoft’s Excel Macro Crackdown.

    If you have any questions for Susan about her ComputerWorld article this topic is being discussed in her 07-Jul-2022 AskWoody.com thread Dear Microsoft, Don’t Give Up On This Please!.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-08-04T15:12:53+00:00

    How do I know what the server name is? This is a hard drive connected to my router so it is not actually a server.

    Was this answer helpful?

    0 comments
  3. lmacri 2,505 Reputation points
    2022-08-05T19:17:45+00:00

    How do I know what the server name is? This is a hard drive connected to my router so it is not actually a server.

    Hi HaydenDavies:

    The allthings.how article How to Find the Path of a Network Drive in Windows 10 might have some useful suggestions. I'm not sure, but in your case I think if you enter net use in a command prompt it should display the standard UNC naming convention (i.e., in the format "\<hostname>&lt;sharename>" that logically identifies a volume or storage device) for your mapped network drive.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-08-11T06:30:32+00:00

    Thank you
    it's working with me

    Was this answer helpful?

    0 comments