How to Create a Personal Macro WorkbookThe easiest way to create a Personal Macro Workbook is to record a "dummy" macro. To do this, follow these steps:
- Start Excel so that only a new workbook is open. On the Tools menu, point to Macro, and then click Record New Macro.
- In the Record Macro dialog box, click Personal Macro Workbook in the Store macro in list.
- Click OK. Because you are creating a "dummy" macro, do not click or type anything.
- In the toolbar that appears, click the Stop Recording button.
- On the Excel menu, click Quit. Or, for versions of Excel earlier than Excel X, click Quit on the File menu.
- Click Save when you are prompted to save your changes.
In Excel 98 and in Excel 2001
How to Use a Personal Macro WorkbookTo write or edit VBA code in a Personal Macro Workbook, follow these steps:
- On the Tools menu, point to Macro, and then click Visual Basic Editor.
- In the "Project - VBA Project" window, double-click VBAProject (Personal Macro Workbook) to display the Modules folder within.
- 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.