Windows Excel -vs- Mac Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MrFish - 30 Oct 2007 20:08 GMT

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?

Reply to this Message

JE McGimpsey - 30 Oct 2007 20:27 GMT

> I've got an excel spreadsheet that contains vba macros.
> It works fine in a windows environment where I created it.
[quoted text clipped - 5 lines]
> 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).

Reply to this Message

Mac Forum / Applications / Excel / October 2007

Windows Excel -vs- Mac Excel