Personal.xls

[Guest]

I'm a novice at VBA Excel macro writing (Excel 2000). I'e read that I can
store macros in personal.xls and they will be abailable to all of my
workbooks. But, I don't seem to have personal.xls on my computer(I've
searched where it's supposed to be, as far as I know). Can (how do) I create
this workbook and then use it.

 

[Dave Peterson]

The easiest way may be to record a trivial macro and choose to place it in
"personal macro workbook" on that first "record macro" dialog.

This personal.xls is usually a hidden file, so you'll be prompted to save it
when you close excel. It'll save to the correct spot.

Then when you reopen excel, personal.xls will open (as a hidden workbook), but
you can still record macros into that file as well as editting them in the VBE.

Remember to keep backups!

 

[MC]

JCIrish,

Depending on the version of XL you are running, there is an XLStart folder,
e.g. C:\Program Files\Microsoft Office\OFFICE11\XLStart

Any Excel file placed in this folder will automatically open when you launch
Excel.

Also Excel has a number of start up switches that you can put in the target
for the shortcut. These switches provide additional flexibility. Consult the
Excel help for detailed instructions.

MC