Prevent Delete prompts on worksheets

Lynneth · Feb 15th 2005

When running a macro, and deleting a worksheet as part of the macro, how can I prevent the confirmation box from coming up.

Even though I deleted it as part of the macro, it still appears. I want it not to appear

Any help would be appreciated

Thanks
Lynne

Jong · Feb 15th 2005

Re: Prevent Delete prompts on worksheets

use the following:

Application.DisplayAlerts = false

Then re-enable it once you are done:

Application.DisplayAlert = true

Participate now!