Microsoft KB Archive/288117

= How to create a Personal Macro Workbook in Excel for Mac =

Article ID: 288117

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2004 for Mac
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q288117



SUMMARY
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 &quot;dummy&quot; 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 &quot;dummy&quot; 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 2001



In 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 &quot;Project - VBA Project&quot; 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.

Additional query words: MacXLX MAC XL98 XL2001 XL2004 program VBA code start record personal macro automation automate edit

Keywords: kbhowto kbdtacode KB288117

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.