Mac and Excel

[pantakos]

Hello all ,

I made a project in Excel 365 , using vba and ribbon . I tried to run in on Mac but no luck, stops at the beggining with the error Invalid Procedure call or argument. Also at the project vba there are 2 sheets that have ubnormal characters and I cant find them.

Please if you can help, why it isnt running on Mac, or if someone can help to upload the project.

Thank you
Also posted here MacOS and Excel Vba Crash

 

[pantakos]

Please find attached a sample file
The problem is that some of the users are working with MACos (Big Sur), and although they have Office 365 paid, excel crashed when opening the file.
The sheets are protected and using macro to unlock - lock them, hide sheet (xlveryhidden or normal) , lock cells etc
Can someone that has MAC please check and perhaps find out where the crash occurs.
Cant upload file, so google drive

SampleFile

Thank you in advance!

 

[Jim Gordon]

Hi

The project explorer appears normally in my Excel. Your code errors because there is no object called "Invoices." There isn't an Excel table on PROFORMA worksheet.