VBA Macros NOT cross platform?

[Mike Laufer]

Button that I create on an Excel v.X for the Mac that run
a VB macro run fine on the mac. If I create the same
macro and button on the Excel 2002 for Windows 2000, it
also runs.

But, if I transfer the Mac file to the PC (or the PC
created file to the Mac), the macro buttons don't work!
They're like pasted graphics instead of buttons.

Anyone know how to get macro buttons to work cross
platform?

 

[Tom Ogilvy]

I don't have a MAC, but I suspect the MAC version of Excel supports the old
style dialog sheet, so I would use that in both instances if you need to
move between platforms.

 

[Anders S]

For what it's worth,

In a project I did a while ago, I used controls from the Forms toolbar *on the
worksheet*. They worked just fine under Windows and on the Macintosh as well as
the macros. No problems with custom toolbars either.

I don't have a Mac available, so I can't be more specific.

Win2K/ExcelXP - Mac OS9/Excel97

Regards
Anders Silvén

 

[Howard Kaikow]

VBA on the Mac is a subset of VBA 5.
VBA in Excel 2002 is VBA 6.3.

Would not surprise me if there are incompatibilities.

Creating the button on the Mac would be expected to produce a file that also
ran in Excel 2002.
I expect that there are problems going the other way.

Instead of a button on the Excel sheet, have you tried to instead use a
toolbar button or a Userforms?