If you haven't you need to create it first, you can do that by recording a
dummy macro, just do toolsmacrorecord new macro and select personal macro
workbook, then stop the recording, then press Alt + F11, find the
personal.xls in the project pane to the left, double click the module and
delete whatever was recording, then you can put your macros there. Finally
when prompted to save it upon closing Excel select yes

--
Regards,

Peo Sjoblom



"Janis" wrote in message
...
That sort of answered my question. I was confused because that is how you
do
it on a Mac. That begs the question. How do I find this hidden
"personal.xls" workbook so I can store my personal macros in it? That was
the original reason for me trying to create that file in the first place.
thankx,

"Michael M" wrote:

Hi Janis
Personal.xls is a hidden file created by Excel itself where you store
macros
to be used each time Excel opens.
I would highly recommend you do not use this filename for your "personal
information" spreadsheet.

HTH
Michael M

"Janis" wrote:

I don't know if I have my personal.xls workbook set up right. There
was no
Excel File in my office directory. There are several files called
office
with a number. One of them looked like Excel so I created an Office
folder
and created a workbook called personal.xls.

When I open a workbook it seems to have access to these scripts but
they
don't seem to run.

thanks,