ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Running Windows-Excel macros on Macintosh (https://www.excelbanter.com/excel-programming/303167-running-windows-excel-macros-macintosh.html)

SunTzuComm

Running Windows-Excel macros on Macintosh
 
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

Running Windows-Excel macros on Macintosh
 
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.



In article ,
(SunTzuComm) wrote:

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?


SunTzuComm

Running Windows-Excel macros on Macintosh
 
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!


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com