Can I make my Excel Macro work on a Mac computer?

Dear Excel users

I have written an Excel macro, which do a lot of calculations via loops, conditional statements, when some command buttons are pressed. Numbers are being placed in cells and there are coloring of cells, but no interaction with the Operating System (files, etc.). My macro is made for educational purposes and will run on Windows computers. However quite a few of our students own a Mac computer, so I wonder if I can somehow make my Macro run on these as well? Is command buttons a problem? If so, is there a way to work around it?

NB! We use the newest Excel software via Microsoft 365.

Kind regards,

Erik

As long as they don't call for any windows API or libraries, they should work fine.

Originally Posted by erik11

Is command buttons a problem? If so, is there a way to work around it?

If they are ActiveX buttons, they won't work on a Mac, but you can possibly replace them with shapes.

Shapes shouldn't be necessary as there is still the form control buttons which are supported on Mac.

You can use either, I just find the buttons to be ugly & prefer shapes.

Thanks for the replies. I actually agree that the buttons are not that smart looking anymore - look like it was done 20 years ago. Is it possible to use a shape or Form button instead of a Command Button? What is needed is that the code is executed when I press this item (Form button or shape). Here is a tiny part of the code:


Private Sub CommandButton4_Click() 'Step in votes
Dim PartyNumber As Integer
PartyNumber = Cells(4, 8)
Cells(StartRow + PartyNumber, 2) = Cells(StartRow + PartyNumber, 2) + Cells(4, 9)
Call CommandButton1_Click
End Sub

Kind regards,

Erik

Just insert your shape, right click on it and assign a macro.