VBA issues between desktop excel and MAC

[Simmo1313]

Hi all,

I had a sheet created for me that has some push buttons for login and other tasks I run excel 2016 from my laptop..

When I gave the sheet to someone with a MAC they did some work saved it and sent it back to me.

I then found none of the push buttons work.

I viewed the code and matched the old version up against the new and found in the drop down menus at the top of the relevant sheet code had changed

Original working version has CommandButton2 and Click as the two drop down menus (left and right respectively) and then below that is all the private sub code

No longer working version has (General) and CommandButton2_Click as the two menu options, all the private sub code is the same.

Was wondering if anyone could shed some light on;

A) why this would happen, and
B) how do I fix it as the original menu options are no longer available in the drop down menus

Much appreciated

 

[Michael M]

Pretty simple....MAC and PC don't like each other !!
MAC will save the workbook differently to PC, so I'd suggest if you are going to cross platform, don't send workbooks with code !!

 

[Jim Gordon]

Excel on the Mac should never change your code. However, if these are Active-X controls and the Mac user saves the file then content will be stripped out because there is no Active-X support for Mac OS. Use legacy controls only if you want your controls to be cross-platform.