Problem after "save as"
Posted by Mike on December 18, 2001 11:36 AM
I have an Excel sheet at work with LOTS of macros attached to it. I saved the worksheet as a different file name so I could make changes and e-mail it to someone. Now anytime I try to execute any of the macros in the original worksheet, it first opens the file that I "saved as" before it'll execute the macro. I deleted the file that I'd "saved as" and now it won't execute a macro at all. It gives me an error message saying it can't find a specified file. I've checked over the VB coding of the macros to see if Excel made reference to the new file that I'd saved, but can't find it referenced anywhere in the code.
Anybody ever encounter this problem and is there a remedy short of recreating all of my many macros?