Wakelin Solutionz Pty Ltd

SPECIALISTS IN PERSONAL & ORGANISATIONAL PRODUCTIVITY

Phone: +61 421 551 254      Email:  wakelinsolutionz@bigpond.com

Create a personal.xls macro workbook to store your macros in

It is useful to store all your macro code in one place.  This allows you to reuse the code on a number of different workbooks.  You can set it up so your macro workbook is opened and available whenever Excel is opened. 

It is a good idea to hide your macro workbook so you don't reuse it as another workbook.

1. Create a new Excel workbook and call it Personal.xls 

2. Save a copy of this file onto a directory on your computer that is backed up regularly

3. Create a shortcut to Personal.xls

4. Put the shortcut into the Excel start directory.  This is usually C:\Program Files\Microsoft Office\Office\XLStart (in some versions it may be Office10\XLStart)

5. Open Excel (which will automatically open your Personal.xls workbook)

6. Click on Windows and Hide

7. Exit Excel and click Yes to save Personal.xls.  This will save the hidden property for the workbook

When you create a new macro, make sure you select to store the macro in Personal.xls.

To edit macros in a hidden workbook, you must first unhide the workbook.

1. Click on Windows and Unhide

2. Select the workbook with your macros in (e.g. Personal.xls) and click OK

3. Once you have made the changes to the macro, make sure you hide the workbook and save the file as you exit Excel.

VBA Tips Index