How to open vba code in excel on Mac Air?

Question

Level 1

5 points

Some one sent me an xlsx file produced on VBA. On a PC you can access the code with Alt F11 but that does not work on Mac.

There must be an alternative procedure. Thanks in advance for a suggestion. I am on OS X Lion

MacBook Air, iOS 5

Posted on Nov 27, 2011 8:37 AM

Reply

Answer 1

Level 4

2,532 points

If you have Excel 2011, you enable the Developer Ribbon, then you'll have access to the VB Editor:

I do not know how "complete" the VB is in Excel 2011 because IIRC, previous versions of Excel for Mac did not have VB.

Reply