personal.xls is used by lots of people to keep the general macros (and
functions) that they always want available when they start excel.
If you do Tools|Macro|Record new macro, one of the options to store the recorded
macro is in "personal macro workbook".
If you already have the code written, you can copy the procedure into the
project for personal.xls.
Then make sure you save this personal.xls into your XLStart folder.
In fact, many people want this workbook to open up hidden--just to avoid the
look of "clutter" of having multiple workbooks open--and it makes it more
difficult to close the workbook by mistake.
If you've created your personal.xls file, you can use this (inside Excel):
Make personal.xls the activeworkbook
then Window|Hide
Then close excel. You'll be prompted asking if you want to save personal.xls.
Answer yes.
Since you saved this file in your XLStart folder, it'll open each time you start
excel.
One way of finding that XLStart folder is:
Open excel
hit alt-f11 to see the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath
For me (xl2002 and win98), I get:
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART
Each time you add/change something in that personal.xls file, remember to back
up a copy to a nice safe location.
And if you a way to make your macros more accessible than Tools|macro|macros...
John Walkenbach has a nice workbook that actually creates another option on the
worksheet menubar.
http://j-walk.com/ss/excel/tips/tip53.htm
It's called menumaker. It's really simple to use and looks very
nice/professional.
