Run VB code in Excel on a Mac

[bgmapes]

I am a Windows user and I am trying to help a 3rd grade teacher with sorting and printing information on the students in all the 3rd grades of her school. Since I work on a windows machine and she on a mac, I thought I could developed something on Excel that she could use.

I know a lot about vb and databases and a little about Excel. I used the vb tools to make a command button that when clicked on would print "This works" in cell A1. This works fine on my computer. However when I sent it to her and she tries to run the code by clicking on the run button, she get a box asking her what macro she wants to run. There is no macro, just VB code in the button.

What am I missing?

Thanks for your help and understanding,

Bruce Mapes

 

[JE McGimpsey]

I am a Windows user and I am trying to help a 3rd grade teacher with sorting
and printing information on the students in all the 3rd grades of her school.
Since I work on a windows machine and she on a mac, I thought I could
developed something on Excel that she could use.

I know a lot about vb and databases and a little about Excel. I used the vb
tools to make a command button that when clicked on would print "This works"
in cell A1. This works fine on my computer. However when I sent it to her
and she tries to run the code by clicking on the run button, she get a box
asking her what macro she wants to run. There is no macro, just VB code in
the button.

What am I missing?

Currently, ActiveX (e.g., controls from the Control Toolbox) is a
Windows-only technology.

You need to use a Forms toolbar button instead, with a macro in a
regular code module attached.