Deleting PERSONAL.XLS (Resolved)

Rocky E · May 21st, 2002, 01:31 PM

Hi,
I created a PERSONAL.XLS the other day and now I can't get rid of it. I have deleted PERSONAL.XLS from the XLSTART directory and scanned for other copies even on the network. Still every time I go to record a macro it wants to store it in PERSONAL.XLS. Also it says that the workbook is hidden and refuses to let me edit it? Exactly how do you unhide this workbook and then get rid of it?
Thanks in advance! All suggestions appreciated.

Rocky...

[ This Message was edited by: Rocky E on 2002-05-21 13:00 ]

Tommy Bak · May 21st, 2002, 01:50 PM

hi
why do you want to get rid of that ?
I think it's a very usefull book to store personal makro that I would like to store and use daily.

If you have deleted all occurences of personal.xls it's gone but excel will always ask that question when you record a macro and if you choose to store i personal excel will make a new file called personal.
So you can delete it, but you'll get a new one if you store a makro in it.
You unhide it under "Window / Show"

regards Tommy

Rocky E · May 21st, 2002, 02:05 PM

Thanks Tommy,
If you Insert a Module in the workbook it will stop the prompt for PERSONAL.XLS. I guess I must have always had a macro or two already stored. The reason I don't want a PERSONAL.XLS is I am working on a XLA for others that may already have one. Users get upset when you overwrite their stuff.
Thanks again...

Rocky...

[ This Message was edited by: Rocky E on 2002-05-21 13:06 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 01:31 PM	#1
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Hi, I created a PERSONAL.XLS the other day and now I can't get rid of it. I have deleted PERSONAL.XLS from the XLSTART directory and scanned for other copies even on the network. Still every time I go to record a macro it wants to store it in PERSONAL.XLS. Also it says that the workbook is hidden and refuses to let me edit it? Exactly how do you unhide this workbook and then get rid of it? Thanks in advance! All suggestions appreciated. Rocky... [ This Message was edited by: Rocky E on 2002-05-21 13:00 ]

May 21st, 2002, 01:50 PM	#2
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	hi why do you want to get rid of that ? I think it's a very usefull book to store personal makro that I would like to store and use daily. If you have deleted all occurences of personal.xls it's gone but excel will always ask that question when you record a macro and if you choose to store i personal excel will make a new file called personal. So you can delete it, but you'll get a new one if you store a makro in it. You unhide it under "Window / Show" regards Tommy

May 21st, 2002, 02:05 PM	#3
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Thanks Tommy, If you Insert a Module in the workbook it will stop the prompt for PERSONAL.XLS. I guess I must have always had a macro or two already stored. The reason I don't want a PERSONAL.XLS is I am working on a XLA for others that may already have one. Users get upset when you overwrite their stuff. Thanks again... Rocky... [ This Message was edited by: Rocky E on 2002-05-21 13:06 ]