Need to stop personal.xls from opening with every Excel doc?

W

wfd37

Each time I open an Excel document a second document called personal open
along with it. What did I do to have this happen and how do I stop it?

Thanks
 
M

Marcelo

Hi,

you have a personal file recorded on C:\program files\microsoft
office\office11\startup.

remove or delete this file to stop it.

hope this helps
regards from Brazil
Marcelo

"wfd37" escreveu:
 
G

Gord Dibben

Personal.xls ia your personal macro workbook.

You must have recorded a macro and selected personal macro workbook as the file
to store it in.

You can delete this file from your XLSTART folder usually located at

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

OR....keep it and let it open.

When it is open, go to Window>Hide and select Personal.xls.

Save changes to Personal.xls when you close Excel.

Personal.xls will now open "hidden" and any macros in it will be available for
all workbooks, which it was designed for.


Gord Dibben MS Excel MVP
 
N

Nick Hodge

Do NOT delete it unless you are sure it contains no code. It should be a
hidden workbook and opens everytime Excel does, you just shouldn't see it

Get personal.xls as the active workbook and select window>hide, now close
Excel and answer yes if it says you have made changes to personal.xls and
all will be well

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
S

Sam

wfd37 said:
Each time I open an Excel document a second document called personal open
along with it. What did I do to have this happen and how do I stop it?

Thanks
Click to expand...
 
Top