Excel - opening 2 files - Try again
Posted by Tee on June 28, 2001 4:53 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 and I have 2 custom toolbars (diffent names).
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.