macros in excel from pc spreadsheet

B

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!!
 
B

Bernard Rey

Brian said:
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
Click to expand...

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...
 
B

Brian

Cool.

Thanks


Bernard Rey said:
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...
Click to expand...
 
Top