Excel on the Mac

[mortgageman]

I was recently in an Apple store and was checking out the Mac. I went into Excel and aside from the fact that it looked nothing like Excel on the pc, I couldn't find a way to get into the VBA environment.

Basic question is this - Can I take a excel 2003 sheet - that has VBA macros - and run it on a Mac? (I'd rather know before I buy )

Thanks

 

[mortgageman]

Yes. My Excel 2008 is patched up to 12.1.1 and if you open a workbook with vba macros you still get the warning about them not working (and the option to remove them). <snip>

This sounds way dumb - not you Rorya, the Apple generated "option". What would be the point of removing macros, when, presumably, they are part of the spreadsheet design. I mean if they weren't being used, they wouldn't be there in the first place. So Apple's portability option is to allow users to run dangerously broken (since they might actually generate incorrect results, instead of only **name not found**) spreadsheets from the pc to their platform?

 

[RoryA]

I assume it's an MS Generated option, not an Apple one, as it appears to be an Excel generated warning. It's pretty similar to the warning you get in 2007 if you try and save a workbook as .xlsx when it contains macros. (it's actually a handy feature in my opinion that you can strip all code out of a workbook just by saving it a particular way - a lot easier than trying to remove everything from the VBProject in code!)