Macworld Forums: MS Excel fo Mac - Macworld Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

MS Excel fo Mac

#1 User is offline   NealC Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 30-October 07

Posted 30 October 2007 - 11:13 AM

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?
0

#2 User is offline   shades Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 344
  • Joined: 28-June 02

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

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

2 User(s) are reading this topic
0 members, 2 guests, 0 anonymous users