Macros being used on Mac's

**ashw** · 10-04-2011, 08:04 AM

How can I make a macro work on both a PC and a mac, from the same workbook?

RIght now it wont even register that there is a macro recorded and it is needed, so how can i get it to work???

**royUK** · 10-04-2011, 08:09 AM

Firstly it depends which version of Office on the Mac, some earlier versions don't support VBA

**ashw** · 10-04-2011, 09:21 AM

it is 2007 version....

**royUK** · 10-04-2011, 10:11 AM

As far as I know there is no Office 2007 for the Mac

**ashw** · 10-07-2011, 06:04 AM

Sorry I dont use MAC's so im not certain...

It will be whatever the latest version is though!

**royUK** · 10-07-2011, 07:52 AM

I don't use a Mac but I think the VBA code can differ. If you are coding for both then you need a Mac to test on

**romperstomper** · 10-07-2011, 08:21 AM

The latest version is Excel 2011 which does support macros; from what you have said, I suspect the version you are trying to work with is 2008, in which case you cannot use VBA in any way shape or form.