application.dispayalerts = false
ActiveWindow.SelectedSheets.Delete
application.displayalerts = true
--
HTH...

Jim Thomlinson


"Colin Hayes" wrote:


Hi All

As part of a macro , I use this command :

ActiveWindow.SelectedSheets.Delete

On each occasion I run it , I get a popup which ask me if I really want
to delete the relevant sheet. This brings the whole macro to a halt.

Is there a command I can use to avoid the popup , and have the macro
perform the deletion without stopping the whole routine?

Grateful for any help.



Best Wishes
.