Windows Excel -vs- Mac Excel

[MrFish]

I've got an excel spreadsheet that contains vba macros.
It works fine in a windows environment where I created it.
My friend who needs to use it has a mac with MS Excel for the mac.
There is a button on the spreadsheet that fires the macro. That button
isn't clickable on the mac version. Also he can't go straight to the
macro and run it.

Is there something standard that needs to be done for vba macros to
work on the mac version?

 

[JE McGimpsey]

I've got an excel spreadsheet that contains vba macros.
It works fine in a windows environment where I created it.
My friend who needs to use it has a mac with MS Excel for the mac.
There is a button on the spreadsheet that fires the macro. That button
isn't clickable on the mac version. Also he can't go straight to the
macro and run it.

Is there something standard that needs to be done for vba macros to
work on the mac version?

VBA macros work fine, as long as they are VBA5-compatible.

But your button is an ActiveX control from the Control Toolbox. ActiveX
is currently a Windows-only technology. To make the application work
cross-platform, replace the ActiveX button from the Forms Toolbar
(attaching your macro to it).