Disabling worning message while closing a workbook.

[arrun]

Dear all,

I have created an excel workbook with lot of VBA codes. However when I close this book I am getting a warning message :

"A formula in this worksheet contains one more invalid references. Verify that your formulas contain a valid path, workbook........."

However, now it is no possible to check each code from where it is coming due to time constraint [deadline to submit this book is just tomorrow ]. Is there any way (preferably VBA code) to disable this warning?

Your help will be highly appreciable.

Regards,

[Bob Phillips]

So you are proposing submitting a workbook as completed with a known problem?

Don't know if this will overcome that message, but you can always try

Application.DisplayAlerts = False

[arrun]

Still it is coming. Actually it is coming when I press "close" button (top-right), any other idea?

[arrun]

Ok leave it. I found the problem and fixed