This problem might be related to the VBA compatibility.Īs your problem is related to VBA code in Excel 2016 for MAC, I suggest you post your issue to answer forum of Excel 2016 for MAC and provide the code: As you said the your file and code is created on earlier version of Excel for MAC, and you cannot use with Office 2016 for MAC.