How to create a Personal Macro Workbook in Excel for Mac

This article describes how to create a Personal Macro Workbook for writing and editing Microsoft Visual Basic for Applications (VBA) macros that you cannot record.

How to Create a Personal Macro Workbook

The easiest way to create a Personal Macro Workbook is to record a "dummy" macro. To do this, follow these steps:

1. Start Excel so that only a new workbook is open. On the Tools menu, point to Macro, and then click Record New Macro.
2. In the Record Macro dialog box, click Personal Macro Workbook in the Store macro in list.
3. Click OK. Because you are creating a "dummy" macro, do not click or type anything.
4. In the toolbar that appears, click the Stop Recording button.
5. On the Excel menu, click Quit. Or, for versions of Excel earlier than Excel X, click Quit on the File menu.
6. Click Save when you are prompted to save your changes.

When you start Excel, this Personal Macro Workbook opens as a hidden workbook. By default, it is stored in the following path, depending on your version of Excel.

In Excel 98 and in Excel 2001In Excel X or in later versions

How to Use a Personal Macro Workbook

To write or edit VBA code in a Personal Macro Workbook, follow these steps:

1. On the Tools menu, point to Macro, and then click Visual Basic Editor.
2. In the "Project - VBA Project" window, double-click VBAProject (Personal Macro Workbook) to display the Modules folder within.
3. Double-click the Modules folder to display any modules in this project, and double-click a module to display its code or blank code sheet.
   
   You can use this code sheet to write and edit VBA code.