How to stop Personal.xls opening at startup

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
 
J

JE McGimpsey

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.
 
P

Peo Sjoblom

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
 
M

michele

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...
 
M

michele

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
 
D

Dave Peterson

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.
 
Top