How can I make Excel Macros created on PC work on Macintosh?

[Guest]

I run a network which is mostly Macintosh. Some clients are emailing us
spreadsheets they want us to use, which contain Macros. These Macros don't
work in Excel on the Macs, even after clicking the 'enable macros' button.
Does anyone have any idea how to make them work?

Thanks.

 

[JE McGimpsey]

MacXL VBA is version 5.00, so macros cannot use VBA6 functions (e.g.,
Join, Split, Replace). If the macros run in WinXL97, they'll generally
run in MacXL98/01/v.X/04.

ActiveX controls (i.e., from the Control Toolbox) are Windows-only, so
will not run in MacXL. Use the Forms controls instead.

There are a couple of other small differences that are listed in MacXL
VBA Help.