Excel is opening 2 files - HELP !!!!!

Posted by Tee on June 26, 2001 7:17 PM

Hi Everyone

I am at my wits end. I have made a copy of 1 excel (B) file and placed it on another drive. There is an Auto Open macro in each. On someone's suggestion, I remove the Application etc line to just read the name of the sub that I am calling. eg Max_Prepare. in both files. (A & B)

All the macros in the copy file (B) I have renamed as well. And the custom toolbar.

When I open the copy (B) it is fine and does not open the orginal (A) but as soon as I click on the custom toolbar in file (A) - it opens the file (B).

I am about to delete the whole thing and give up so any help would be greatly appreciated.

Tee

Posted by mseyf on June 27, 2001 5:45 AM

my guess is that something on the custom toolbar on file(A) is calling a macro in file(B). Microsoft has an add-in/wizard called dellinks.exe that may help find the culprit.(or maybe you could temporarily rename file(B) and then open file(A) to see if you can deduce what the connection is)

-Mark