Help with macros in Office For Mac 2011

I wonder if anyone with Office For Mac 2011 can give me some help.

I have a Microsoft Excel workbook that contains Macros.
I would like to know if the Workbook and the Macros will perform correctly in Office For Mac 2011.
Do Macros work in 2011?

I have attached a zipped up Excel Workbook that contains Macro driven buttons.
If the Macros are working then when a button is pressed the user will be taken to the related Worksheet.

Do the buttons work on your Mac Office 2011?

I have a number of clients that may need to upgrade to 2011, but I cannot advise this until I know that the Windows Macros will work.

Thanks in anticipation

Steve

(I can send the xls file via personal email if the zip will not unzip on the Mac.)

Tests

Hi EmilJan

Thanks ever so much for taking the time and trouble to test the workbook on your Mac and Windows system and getting back to me. It is greatly appreciated.
I can now see what is happening on the Mac (not a lot by the look of it).

Thanks

Steve

tests

Hi MisterMe

Thanks very much for your input on this matter. Your comments have given me a few ideas and opened up my horizon.

The Workbook automation makes use of Vba code and also UserForms. I am wondering if UserForms is the cause of this problem maybe the support/engine for this is not present (or has changed) on the Mac.

I will also try saving the Workbook in Excel 2010 and create an .XlsX file.

update ... after a bit of googling with 'userforms' I came across a discussion where a coder has had to alter the syntax of some code lines, to make them compatible with Excel2011.mac (rather much like changing VB6 code to DotNet code). I am now thinking I may have to alter the code to make it compatible with the Vba in Mac 2011 (Vba7?).

When you say it works fine in Excel 2003 and fails in Excel 2004, was this test done on a Mac? The code was written in Excel 2000. As far as I know the Workbooks perform ok on all Excel.win versions up to 2010.


Thanks

Steve