Running macros in office documents

[cool11]

Is there any way of running properly, microsoft excel or word files that include macros, in our macs?
I have such files, they seem that they cannot run properly, as they do when you run them in windows.

 

[bogdanw]

For security reasons, Microsoft has restricted the use of macros
Enable or disable macros in Office for Mac
https://support.microsoft.com/en-us...-for-mac-c2494c99-a637-4ce6-9b82-e02cbb85cb96
Excel 4.0 (XLM) macros now restricted by default for customer protection
https://techcommunity.microsoft.com...stricted-by-default-for-customer/ba-p/3057905
Macros from the internet will be blocked by default in Office
https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked

 

[cool11]

Let my clarify the situation.

1st step:

I click enable.

2nd step:
I press a button inside excel, that it is supposed to run a macro.
Here you see what happens:

----

So, it does not run well.
A visual basic problem?
The same excel files, run properly in windows.
So what is missing on mac?

 

[bogdanw]

There are additional settings related to Visual Basic.
Set preferences for macro security in Office for Mac
https://learn.microsoft.com/en-us/deployoffice/mac/set-preference-macro-security-office-for-mac
You can write them directly into ~/Library/Preferences/com.microsoft.office.plist or use a configuration profile created with iMazing Profile Editor https://apps.apple.com/app/imazing-profile-editor/id1487860882
Getting started with iMazing Profile Editor https://imazing.com/guides/getting-started-with-imazing-profile-editor

 

[MikeDr206]

I seem to recall reading somewhere that full Visual Basic capability is not available in the Mac Office 365 products. So documents with macros developed in Windows Office 365 won’t necessarily run on Mac.

My understanding could be full of poo, but I wouldn’t assume that it’s a permissions or configuration issue preventing you from running the macros.

 

[bogdanw]

Starting with Office 2016:
"Office 2016 for Mac is sandboxed
Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed.
Sandboxing restricts the apps from accessing resources outside the app container. This affects any add-ins or macros that involve file access or communication across processes. You can minimize the effects of sandboxing by using the new commands described in the following section."
https://learn.microsoft.com/en-us/office/vba/api/overview/office-mac