depends on the version of office installed. >= office 13 you should have vba 7.1.
while vba is the same, the office object models are different on the Mac from windows. also vba on a Mac runs in a sandbox, and has restrictions. see:
https://learn.microsoft.com/en-us/office/vba/api/overview/office-mac