I'm not sure if this will work.
Step through your code with F8 on the keyboard until the message pops up and make a note of which line caused it, then edit the macro to include the line:
just before it, and later add the line:
to restore it so that future alerts appear as normal (this applies to the user interface messages too, such as when deleting a sheet manually).