You may not have one.

If you never recorded a macro to your Personal Macro Workbook you won't.

Start up Excel and any workbook.

ToolsMacroRecord new macro.

When the record macro dialog opens select "Personal Macro Workbook" from "store
in" dropdown.

Do a couple of things like copy a cell from one place to another or similar.

Hit the stop recording button. Do not hit the "x" to stop recording.

You now have a Personal.xls stored in your Office XLSTART folder.

It will open hidden whenever Excel starts.

Your macros will be stored in there.

Hit Alt + F11 then CTRL + r to see the Personal.xls workbook and its modules.


Gord Dibben MS Excel MVP


On Thu, 30 Aug 2007 11:12:04 -0700, Tay wrote:

where can I find the Personal.xls. I am using excel 2003.

"Gord Dibben" wrote:

You would be best of placing the code into your Personal.xls file which will
open whenever Excel is opened.

The code will work on whichever workbook is active.

Or place the code into a new workbook and save as an Add-in which you would load
through ToolsAdd-ins.


Gord Dibben MS Excel MVP


On Thu, 30 Aug 2007 09:22:03 -0700, Tay wrote:

After I have created the NumberAsText in one spreadsheet, how do I enable the
same to be used in other spreadsheet?