Give this a whirl...

Application.DisplayAlerts = False
Sheets("Sheet1").Delete
Application.DisplayAlerts = true

--
HTH...

Jim Thomlinson


"Nicholas B" wrote:

Anyone know if its possible to switch off prompting for confirmation when a
macro wants to delete a sheet ?

I've tried using sendkeys with " " to click the default button but that
doesn't seem to work.

Thanks, Nick