Run Ro In Excel 2010 Code And Also

I produced several custom macros in Windows, modified the XML so that a custom Im now trying to produce equivalent functionality for Excel 2011 for Mac.

For redundancy, I also added a new menu to Toolbars and Menu and added all my macros to that toolbar as well.

Your macro has to be located in your Personal Macro Workbook.

Under Store macro in: click the drop-down and select Personal Macro Workbook.

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.

Click to expand.I am in the process of examining this workbook in Excel:win.

However, it is clear that it has some conceptual problems.

The most obvious is that an.xls spreadsheet is not the native format of Excel 2010 and Excel 2010.

An.xls workbook should be compatible with Excel 2003 and Excel 2004.

My attempt to open it in Excel 2004 resulted in a compile error.

My experience with Excel 2011 was the same as emiljans--the workbook froze the application.

By this I mean that VBA has the complete run of the system in Windows.

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.

Run Ro In Excel 2010 Code And Also

The Workbook automation makes use of Vba code and also UserForms.

I am wondering if UserForms is the cause of this problem maybe the supportengine 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.

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.

How To Run Macro In Excel 2010 For Mac