Many of the file handling operations for the Mac (Mac Office 2016) are different. This is a good reference to the workarounds.
http://www.rondebruin.nl/mac/section3.htm
I've been generally frustrated by the VBA implementation for Mac Office 2016, and prefer Mac office 2011.
Jim