Excel is opening 2 files - HELP !!!!!
Posted by Tee on June 26, 2001 7:17 PM
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.