Will .XLSM spreadsheet created in Excel 2013 Windows 8 work on a Mac?

[tearsmith]

After reading through some of the day's posts, one caught my eye. I don't want to panic if there's no reason.

I created an excel worksheet full of VBA macros, formulas, modules, userforms, etc. I use Windows 8, some of my co-workers use Windows 7, but my boss insists on using a Mac. Is this spreadsheet going to open and run with no problems, or am I going to have to build Mac code into it? Which I do not know how to do, by the way.

Please help!

Thank you, Tearnie

 

[RoryA]

Unfortunately, the simple answer is that it depends on the workbook. It may be compatible or it may not. Formulas should mostly be compatible, apart from anything new to Excel 2013 (i.e. not in Excel 2010 or earlier), but there are many little - and some not so little - differences in VBA.