How to create a Personal Macro Workbook in Excel for Mac

Article translations Article translations
Article ID: 288117 - View products that this article applies to.
This article was previously published under Q288117
Expand all | Collapse all

On This Page

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.

MORE INFORMATION

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 2001
Microsoft Office folder:Office:Startup:Excel:Personal Macro Workbook
In Excel X or in later versions
Hard disk drive:Applications:Microsoft Office version:Office:Startup:Excel:Personal Macro Workbook

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.

Properties

Article ID: 288117 - Last Review: October 6, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
Keywords: 
dftsdahomeportal kbdtacode kbhowto KB288117

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com