How to stop Personal.xls opening at startup

  • Thread starter Thread starter michele
  • Start date Start date
M

michele

Hi,

Somehow I've got this file starting automatically when I open Excel
2003. How can I make it stop? And what does it do? I hope I don't
need it.

Thanks,

Michele
 
Personal.xls is the default name of the workbook that XL creates in the
XLStart folder when you store a macro. It's just a workbook, but since
it lives in XLStart, it's opened each time XL is opened.

To "make it stop", move or delete the file.
 
Or hide it, it won't stop it from opening but it won't display and any macros
in there will be available

Regards,

Peo Sjoblom
 
JE said:
Personal.xls is the default name of the workbook that XL creates in the
XLStart folder when you store a macro. It's just a workbook, but since
it lives in XLStart, it's opened each time XL is opened.

To "make it stop", move or delete the file.
Click to expand...
 
Hi,

I have lots of macros and if I delete it, will I loose my macros or
just the macros in the personal.xls file (which there are none)?

I can't find the file to delete it. I looked in C:\Program
Files\Microsoft Office\OFFICE11\XLSTART, but the directory is empty.
Where else could I look. I even did a Windows Explorer search and it
didn't find Personal.xls.

Thanks,

Michele
 
Depending on your upgrade path, you may be able to find it via:

Open excel
hit alt-f11
hit ctrl-g
type this in the immediate window:
?application.StartupPath

I get this back (winxp/xl2003):
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

=====
In fact, if personal.xls is open, you can find it via:
get to the VBE again (alt-f11)
hit ctrl-g
type this:
?workbooks("personal.xls").fullname

That should be definitive.
 
Back
Top