MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?

Posted by Rick E on December 18, 2001 12:00 PM

Open your workbook and then open the Macro dialog box, (Tools/Macro../Macro..) delete the macros that refer to the "Save As" workbook, you should see 2 sets of macros, one for the current workbook and one for the "Save As" workbook names.

Good luck, Rick E.

Posted by Mike on December 18, 2001 12:33 PM

It doesn't display the second set of macros (for the saved as file) until I try to execute a macro. But I went ahead and tried to run a macro. After it opened that second file, I then deleted all referenced macros like you said. Now, it tells me that it can't find a macro that's in that second file. Somehow it's still referencing to that file. Akk! I'm scared now. This is a file we use daily at work. I still have a couple of ideas to try (like cutting and pasting sheets and VB coding) I may give that a go.

Thank you for the help!