Macro security behavior

[NatKK]

Hi, do anyone understand this strange behavior?

Env:
L.O. 6.2 latest,
Win 7, Win 10

Macro security settings: Trusted file location

Network share with many calc files (>10000)

A local calc files with a macro to open a file on share if exist or create and open new file.

User A is local Admin on all WS, other users are Power Users

WS 1 Win 10, other Win 7

File creation is OK, when macro attempt to open (new or existing file)

User A on WS 1 OK

User A on WS 2 OK

User A on WS 3 Macro security warning

User A on WS 4 Macro security warning

User B on WS 1 Macro security warning

User B on WS 2 Macro security warning

User B on WS 3 Macro security warning

User B on WS 4 Macro security warning

User C on WS 1 Macro security warning

User C on WS 2 Macro security warning

User C on WS 3 Macro security warning

User C on WS 4 Macro security warning

If Users open file directly from share is OK.

Thank you in advance, Natale Tarantino

[anon73440385]

Macro security settings: Trusted file location

You missed to provide the setting of “Trusted file location”. Which file locations are trusted?

> A local calc files with a macro

The file location of that local file containing the macro must be in “Trusted file location” of each user (which is specific for each user, since there is a user profile for each user).

[NatKK]

trusted locations are: local file path and network share path for each users

[erAck]

Make sure that for the failing constellations Security → Macro Security → Security Level is also set to Very High (only macros from trusted file locations) and not High (only signed macros).

[NatKK]

Yes, Security level is set to very high for all users on each WS.
“If Users open file directly from share is OK.”

[erAck]

I don’t get what is producing the message for you. Already opening a file that was copied from the shared directory to a local path that is in trusted locations? Or a macro running from such file when opened trying to open another file in the shared directory?

[NatKK]

The case is “A macro runned from local opened file try to open another file in the shared directory”
Local and network path are trusted location.
If users try to open the file with file explorer in share no message and open the file