I have a number of general purpose macros in my PERSONAL worksheet. But
the first time I access any of them, XL tells me that there is an
instance of PERSONAL already open (PERSONAL automatically opens when I
open XL), and it can't open another with the same name. I have to close
PERSONAL, the run the macro, which opens PERSONAL. Then I can run the
macros again. Irritating to say the least. Is there a better way?

You may have more than one Personal.xls in your system. It is possible you
have more than 1 Startup folder.

A quick way to find them is to unhide one and open File Properties to see
where it is.
Open the other and do the same.

You are allowed as many as you want - but the names must be different.

Find them and either rename one of them or get rid of it.

If you decide to get rid of it
Rename it
Compare them and consolidate all your code
Dump one of them

--
steveB

Remove "AYN" from email to respond
"davegb" wrote in message
oups.com...
I have a number of general purpose macros in my PERSONAL worksheet. But
the first time I access any of them, XL tells me that there is an
instance of PERSONAL already open (PERSONAL automatically opens when I
open XL), and it can't open another with the same name. I have to close
PERSONAL, the run the macro, which opens PERSONAL. Then I can run the
macros again. Irritating to say the least. Is there a better way?

Steve,
Thanks for your reply. I already checked for mulitple instances. There
is only one on my C drive. I have copied it to my H (network) drive to
back it up, but I didn't think XL would find it there. Is that correct?


STEVE BELL wrote:
You may have more than one Personal.xls in your system. It is possible you
have more than 1 Startup folder.

A quick way to find them is to unhide one and open File Properties to see
where it is.
Open the other and do the same.

You are allowed as many as you want - but the names must be different.

Find them and either rename one of them or get rid of it.

If you decide to get rid of it
Rename it
Compare them and consolidate all your code
Dump one of them

--
steveB

Remove "AYN" from email to respond
"davegb" wrote in message
oups.com...
I have a number of general purpose macros in my PERSONAL worksheet. But
the first time I access any of them, XL tells me that there is an
instance of PERSONAL already open (PERSONAL automatically opens when I
open XL), and it can't open another with the same name. I have to close
PERSONAL, the run the macro, which opens PERSONAL. Then I can run the
macros again. Irritating to say the least. Is there a better way?

Excel should only be opening workbooks (any) that are in a StartUp folder.
Or Add-Ins you have selected.

You may want to check the buttons and see what macro they are assigned to.
If a button is assigned to a macro in any workbook - when you click the
button
you will open the workbook with the macro (where ever it is).

Use the Customize command. Right click on a button and than Assign Macro.
It will show you the name of the workbook where the macro is. (There could
be multiple copies of Personal.xls scattered all over the place)

Get out of that and than click on one of the problem buttons - the offending
workbook will open.
(Unhide it if necessary). Go to the File menu and click Properties. Now
you can see where this workbook is located.

see if this helps (sorry if I went too simplistic)
--
steveB

Remove "AYN" from email to respond
"davegb" wrote in message
oups.com...
Steve,
Thanks for your reply. I already checked for mulitple instances. There
is only one on my C drive. I have copied it to my H (network) drive to
back it up, but I didn't think XL would find it there. Is that correct?


STEVE BELL wrote:
You may have more than one Personal.xls in your system. It is possible
you
have more than 1 Startup folder.

A quick way to find them is to unhide one and open File Properties to
see
where it is.
Open the other and do the same.

You are allowed as many as you want - but the names must be different.

Find them and either rename one of them or get rid of it.

If you decide to get rid of it
Rename it
Compare them and consolidate all your code
Dump one of them

--
steveB

Remove "AYN" from email to respond
"davegb" wrote in message
oups.com...
I have a number of general purpose macros in my PERSONAL worksheet. But
the first time I access any of them, XL tells me that there is an
instance of PERSONAL already open (PERSONAL automatically opens when I
open XL), and it can't open another with the same name. I have to close
PERSONAL, the run the macro, which opens PERSONAL. Then I can run the
macros again. Irritating to say the least. Is there a better way?

Is your personal.xls workbook hidden (it should be)
Window -- hide workbook

Had you used Excel to back up your personal.xls

Tools, options, General
is the alternate startup blank or do you have something in it
if you you do is there a personal.xls in it.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"davegb" wrote in message oups.com...
Steve,
Thanks for your reply. I already checked for mulitple instances. There
is only one on my C drive. I have copied it to my H (network) drive to
back it up, but I didn't think XL would find it there. Is that correct?


STEVE BELL wrote:
You may have more than one Personal.xls in your system. It is possible you
have more than 1 Startup folder.

A quick way to find them is to unhide one and open File Properties to see
where it is.
Open the other and do the same.

You are allowed as many as you want - but the names must be different.

Find them and either rename one of them or get rid of it.

If you decide to get rid of it
Rename it
Compare them and consolidate all your code
Dump one of them

--
steveB

Remove "AYN" from email to respond
"davegb" wrote in message
oups.com...
I have a number of general purpose macros in my PERSONAL worksheet. But
the first time I access any of them, XL tells me that there is an
instance of PERSONAL already open (PERSONAL automatically opens when I
open XL), and it can't open another with the same name. I have to close
PERSONAL, the run the macro, which opens PERSONAL. Then I can run the
macros again. Irritating to say the least. Is there a better way?