VBA/ Macro blocked on network drive

Carlo_Batenb 11 Reputation points
2022-06-23T13:09:51.037+00:00

Good day all,

It seems that the rollout to block macros by default by Microsoft has reached me.

microsoft's article: https://support.microsoft.com/en-us/topic/a-potentially-dangerous-macro-has-been-blocked-0952faa0-37e7-4316-b61d-5b5ed6024216 is giving a simple solution to unblock this.

However, we do not have this option. The files are in a network location (and preferably will remain that way. By the way, the macros are working on a local disk)
I have tried to add this location as a trusted location in Excel, only this is not allowed: ("The path you entered cannot be used as a trusted location for security reasons"). I have tried (using other forums) to enter a UNC location instead of the ip - address or disk location, but to no avail. (The function/ checkbox; Allow trusted locations in my network is on)

Is there a work-around or is this the definitive end of VBA's on a network?
Thanks in advance for your help!

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,459 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. John Korchok 4,926 Reputation points
    2022-06-23T14:55:36.787+00:00

    Using a UNC path is the solution. You only wrote "tried (using other forums) to enter a UNC location instead of the ip - address or disk location, but to no avail". What problem did you have trying to do this?

  2. Carlo_Batenb 11 Reputation points
    2022-06-28T12:34:56.067+00:00

    i added the UNC path as: \NETWORKSHARE\ and also more specific \NETWORKNAME\MAP\MAP2

    Switched on to allow the sub-maps and switched on the "Allow trusted locations on Network " checkbox, but still when I open the macro excel files.
    I got the warning message that Marcos are switched off by Microsoft... ( all local files incl. files on OneDrive don't receive this message when openingen)

    0 comments
  3. Allison Castner 1 Reputation point
    2022-08-10T00:21:19.833+00:00

    I'm having the same problem with multiple Access programs. You can't add a network drive, either by mapped drive or by IP address to the trusted locations. I get the same message OP got above. This is extremely frustrating, because my databases have so many queries and reports and forms that a standard user will not be able to use the database without the VBA switchboards. It makes no sense to take a database from a network server and put it on each person's individual desktop because we can no longer update it without everyone downloading it again.

    All of the power of Access has just been cut by 90% with this roll-out.

  4. Allison Castner 1 Reputation point
    2022-11-14T04:49:50.96+00:00

    @Jim Riley No resolution that I am aware of.

    0 comments
  5. Oskar Shon 866 Reputation points MVP
    2022-11-14T11:22:58.22+00:00

    Yes. Application options is not enough now
    You should add safe serwer place into internet settings

    260171-xl-zablokowane-lokalizacje2-vba-makra.jpg

    And check unblock (if exists) in file properties.