AppleScript is old news, what you had to use in Excel 2008 from which Microsoft had removed VBA. In Excel 2011 for Mac, Microsoft has re-introduced VBA, and it's even finally the same version of VBA that Excel for Windows has been using all along. However, there are a substantial number of differences in how Excel itself behaves between the two platforms, and in how VBA interacts with these platforms. I've only done enough testing to know it's going to be a lot of work to make my stuff compatible. Ron de Bruin has started documenting the differences between Mac and Windows Excel VBA in.

Aug 01, 2011  In Excel 2011 for Mac, Microsoft has re-introduced VBA, and it's even finally the same version of VBA that Excel for Windows has been using all along. However, there are a substantial number of differences in how Excel itself behaves between the two platforms, and in how VBA interacts with these platforms.

Cells.Interior.ColorIndex = 28 Note: instead of ColorIndex number 28 (cyan), you can use any ColorIndex number. To run the procedure, execute the following steps. Click Macros. Windows for mac crashed lost word files. Select Cyan and click Run. Outlook settings for mac email.

Result: Note: code placed into a module is available to the whole workbook. That means, you can select Sheet2 or Sheet3 and change the background color of these sheets as well. The program illustrates how to make a macro available to all your workbooks (Excel files). Remember, code placed on a sheet (assigned to a command button) is only available for that particular sheet.