Error Message When Closing a File

[artvandelay]

I have a spreadsheet model that I've been using that has some database queries, links to other workbooks, etc and every time I close it, I get an error message that says:

cannot find [filename] which has been assigned to run each time [MyFile] is closed. Continuing could cause errors. Cancel closing [MyFile]?

I generally continue with closing the file and then the [filename] workbook referenced in the message is opened, which I then have to close.

I inherited the model and the problem existed from the beginning, so it's not anything I did. I tried using google to find a solution and it seemed like this generally is caused by a macro. Oddly enough, there aren't any macros in my spreadsheet. Has anyone had this problem before? It hasn't caused any serious problems; it's just a nuissance having the warning and another workbook pop up every time I close my model.

 

[VoG]

Press ALT + F11 to open the Visual Basic Editor. In the VBA Project window double click ThisWorkbook. Is there any code in there?

 

[artvandelay]

No, it's blank. I actually just found a site that said it might be caused by bad named ranges. I ran this macro and it seemd to fix the problem. So far I don't think it's messed anything up with the model, but I'm still checking.

<CODE>
Sub Delete_Names()
Dim Nm As Name
For Each Nm In ThisWorkbook.Names
Nm.Delete
Next Nm
End Sub
</CODE>