macros in excel from pc spreadsheet

[Brian]

ok a simple blank sheet with a button on it that produces a message box that
says hello created on the pc. What's the trick to getting it to work on the
mac side? Macros have been enabled but the button appears flat and doesn't
do anything

Thanks alot!!

 

[Bernard Rey]

ok a simple blank sheet with a button on it that produces a message box that
says hello created on the pc. What's the trick to getting it to work on the
mac side? Macros have been enabled but the button appears flat and doesn't
do anything

The button may well be an "ActiveX" Control button (from the "Commands"
toolbar on the PC) If this is the case, it won't run on a Mac version of
Excel. In order to run on the Mac (well, on both platforms), it should
rather be a button from the "Forms" toolbar.

It won't make a difference in the attached macro, I guess, if it's just
intended to say hello...

 

[Brian]

Cool.

Thanks

The button may well be an "ActiveX" Control button (from the "Commands"
toolbar on the PC) If this is the case, it won't run on a Mac version of
Excel. In order to run on the Mac (well, on both platforms), it should
rather be a button from the "Forms" toolbar.

It won't make a difference in the attached macro, I guess, if it's just
intended to say hello...