Share via

Macro workbook on another computer

Anonymous
2023-05-26T18:50:34+00:00

I have a macro workbook that I am trying to save to a shared network drive so others in the company can access, edit, and use the same workbook. It runs fine on my computer, but have been unable to get the macros to run on anyone else's that has access to the shared drive. I have enabled macros on the other computers. I have tried to add location under trust center settings. When they try to open it on another desktop the macros will not run on the spreadsheet. Any ideas how to fix this issue? Thanks

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-05-27T13:26:35+00:00

    You may try:

    1. Another user should also add the network drive as trusted location.  add "\[servername]" as a trusted location
    2. Add trusted site for the netwrok drive. add a file server or network share as a trusted site, by adding its FQDN or IP address to the list of trusted sites.

    Trusted sites dialog

    1. Download the file and put it to local trusted location.

    Add, remove, or change a trusted location in Microsoft Office - Microsoft Support

    Reference:

    Macros from the internet are blocked by default in Office - Deploy Office | Microsoft Learn

    Was this answer helpful?

    0 comments