How to Run Excel Macros in a Mac iWork

Written by ruby neusom
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Run Excel Macros in a Mac iWork
(Ciaran Griffin/Stockbyte/Getty Images)

If you use spreadsheets a lot, you've probably used a mini-program to automate functions in your spreadsheet. These custom macros (or scripts) are frequently programmed into Microsoft Excel spreadsheets, as they can handle complex calculations that simple spreadsheet formulas can't. Macros are written in a programming language called Visual Basic for Applications (VBA). Unfortunately, Apple's spreadsheet application, Numbers, can't read macros that are written in VBA. If you have Apple's iWork 09, however, there are a few options you can try if you still want to use macros in your spreadsheets.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Use AppleScript to create your spreadsheet macros. This is the built-in Mac OS X scripting language. All iWork '09 applications, including Numbers, support the use of AppleScript.

  2. 2

    Switch to using the previous version of Excel for Mac. Excel 2004 supports the use of VBA macros.

  3. 3

    Convert your Numbers '09 spreadsheet to a Windows Excel spreadsheet format. Open your Numbers spreadsheet, and click "File," then "Save As." Select "Save copy as," and choose Excel Document from the pop-up menu. You can now apply macros to the spreadsheet by opening the spreadsheet with a Windows version of Excel.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.