MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Prevent Microsoft Excel information Balloon on VB sheet delete?


Posted by Joe Was on June 19, 2001 8:39 AM

Does anyone know if an Application.X object exists to turn off the conformation/cancel balloon for a sheet delete?

Or know of a way to answer OK in code for this event?
Application.ScreenUpdating=False
and Application.EnableEvents=False
have no affect on preventing the display of this box?


Posted by Dax on June 19, 2001 9:19 AM

Easy - Application.DisplayAlerts=False

Regards,
Dax.

Posted by Joe Was on June 19, 2001 6:01 PM

Thanks Dax

Thank You.