PDA

View Full Version : Disabling worning message while closing a workbook.



arrun
07-24-2007, 09:55 AM
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 :nervous:]. Is there any way (preferably VBA code) to disable this warning?

Your help will be highly appreciable.

Regards,
:help

xld
07-24-2007, 10:08 AM
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
07-24-2007, 10:19 AM
Still it is coming. Actually it is coming when I press "close" button (top-right), any other idea?

arrun
07-24-2007, 10:38 AM
Ok leave it. I found the problem and fixed