We have loads of macros that are now run from a scheduler written in vba. If one of the macros fails a dialog box comes up that stops everything. Is it possible to error trap this or to close the dialog box from code??
There are hundreds of macros which I have inherited. Converting them all to vba is not a practical reality in the near future - anyway they work most of the time. I just wondered if it was possible to close the dialog using code - I assume not. I have posted this on the off chance that I am wrong! The problem is that the vba error handler can only trap the vba errors.