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?
Page 1 of 1
MS Excel fo Mac
#2
Posted 30 October 2007 - 06:02 PM
Howdy. Most likely that button was created on the Windows side, using the Control toolbox, which is not supported on the Mac side. To correct it, have the person who set it up create a new button using the Forms toolbar. That will work on the Mac.
Basically on the Windows side, you have to set up everything in VBA for Excel 97 (based on VB 5), which is roughly comparable to Mac VBA.
Basically on the Windows side, you have to set up everything in VBA for Excel 97 (based on VB 5), which is roughly comparable to Mac VBA.
Page 1 of 1



Sign In
Register
Help

MultiQuote