PERSONAL worksheet problems
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?
|