The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
How to Create a Personal Macro Workbook
by Francis Hayes (The Excel Addict)



A Personal Macro Workbook is used to store macros that can be run in any open workbook.

Do you have a Personal Macro Workbook?

To check if you already have a Personal Macro Workbook, from the View menu select Unhide. If PERSONAL.XLSB is listed, you have one. If not, you can easily create one. Click Cancel on the Unhide dialog.

Create a Personal Macro Workbook

Click the Record Macro button to begin recordingThe simplest way to create a Personal Macro Workbook is by recording a 'dummy' macro.

1) Click the Record Macro button on the bottom left side of the Status Bar (next to the Ready message);

2) In the Record Macro dialog select Personal Macro Workbook from the 'Store macro in' dropdown and click OK;

3) The record macro button on the StatusBar has changed to a Stop button. Click it to stop recording the macro;

4) Next hold down ALT key and press F8 key to open the Macro dialog;

5) Select the macro (probably Macro1) from the list and click the Step Into button. The Visual Basic Editor (VBE) window opens;

6) In the VBE window, from the Run menu, select Reset;

7) You will see the Macro code that was recoded in the Code window;

Sub Macro1()
'
' Macro1 Macro
'

'
End Sub

8) Select this code and press the Delete key;

9) Finally, save your Personal Macro Workbook by clicking the Save button on the VBE toolbar.

You can now record new macros in your Personal Macro Workbook or paste in existing VBA code that you got online or elsewhere.

Note that the Personal Macro Workbook is a hidden workbook, so when you close the VBE window, the workbook remains open but is hidden. Since the workbook is still open, you are not prompted to save changes to your Personal Macro Workbook when you close the VBE window. However, when you attempt to close Excel, you will be prompted to save changes. Personally, I prefer to save changes to my Personal Macro Workbook before closing the VBE window (by clicking the Save button on the VBE toolbar) because, on too many occasions, I have accidentally clicked No to save changes when shutting down Excel at the end of the day.





Would you believe me if I told you that
you can DOUBLE your productivity in Excel?

How about TRIPLE it ? or QUADRUPLE it ? or MORE ?


If I showed you a tip where you could do a task in Excel in five seconds that would typically take you 20 minutes to an hour or more, what would you call that? Productivity on steroids?


...and that's just ONE tip!
 
"Give me 10 or 15 minutes each week and I will show you how learning a few of my time-saving 'Spreadsheet Tips From An Excel Addict' on a regular basis will seem almost effortless BUT will quickly help you BOOST your productivity in Excel beyond your imagination" - Francis Hayes, The Excel Addict

Get my FREE Weekly Newsletter for FREE
"Spreadsheet Tips From An Excel Addict"

Now being read by more than 37,000+ Excel Addicts all over the world

Enter Your Name Francis Hayes (The Excel Addict) - I want to help you EXCEL !!
Enter Your Primary Email

Copyright 2016 TheExcelAddict.com
Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.