How do I stop PERSONAL document opening when I open another doc

  • Thread starter Thread starter Maureen
  • Start date Start date
M

Maureen

When I open an existing Excel file the PERSONAL documents opens too. I
recently recorded a new Macro and this seems to have happened since then.
How do I stop this document opening?
 
If you want to keep the macro available, then most people just hide that window.

Open excel
(in xl2003 menus)
Activate the personal.xls window
Window|Hide

close excel
You'll be prompted to save your change (since you hid that window).
Answer yes.

And reopen excel. Personal.xls will be out of the way, but the macros will be
available for use.

========
If you want to delete personal.xls so that the macros are no longer available.
Open excel
activate the personal.xls window

type this into any cell:
=cell("Filename",a1)
Make a note of the location and file name.

Close excel.

Open windows explorer and traverse to that folder and delete the file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to Fix Damaged Excel File That Won't Open? 3
How do I stop Excel opening up my PDF documents 2
Eliminate creation of backup document every time I open workbook? 1
Need to stop personal.xls from opening with every Excel doc? 4
Getting rid of "PERSONAL" 2
How to unlink TOC from a doc 0
excel opens multiple files upon execution 1
using excel vba ope a word doc and copy-paste into another word doc 0

Back
Top