Bypassing the Delete Sheet Alert (2000 (9.0.4402 SR-1))

Topic

New Reply

I’m deleting worksheets from a workbook using VBA code:

Sheets(“Sheet1”).Delete

This generates an alert box asking if I really want to delete the sheet. No big deal, except when I’m trying to delete 30 or 40 sheets I get an alert for each one! I figure there must be a check box to disable this somewhere in the options, but I sure can’t find it. Anyone know of a way to bypass these alerts?

Thanks.

Reply | Quote

Replies

Before you issue the delete statements, insert APPLICATION.DISPLAYALERTS = FALSE, and after the deletions, reverse it with APPLICATION.DISPLAYALERTS = TRUE.

HTH

Reply | Quote

Just what I needed! Thanks!!

Reply | Quote