Running Windows-Excel macros on Macintosh

[SunTzuComm]

My Macintosh friends say they can open and work with the Windows-created Excel
files I mail them, but the macros in the workbooks do nothing. I'm inclined to
tell them that's why Apple has only 5% market share, but seriously, is there a
solution?

Thanks!
Wes

 

[JE McGimpsey]

Do the macros do nothing? or do you have controls that do nothing?

MacXL doesn't support ActiveX controls - use Forms control instead. All
versions of MacXL use so VBA6 commands will produce compile errors (but
that wouldn't "do nothing"). Otherwise, you'll have to be more specific
- MacXL is 99% compatible with WinXL, and MacVBA is 95% compatible with
WinVBA.

 

[SunTzuComm]

Aha! The worksheet has a button that runs the macro. They say clicking the
button does nothing. I'll see if they can run the macro via the pull-down
menus.

Thanks for the tip!