Use this to turn off the alerts:
Application.DisplayAlerts = False

Also, remebr to turn them back on after you have deleted the sheet:
Application.DisplayAlerts = True


"narutard" wrote:


i have this code that deletes a sheet once i'm done with it. The problem
is, there's a popup window that confirms whether i want to delete this
sheet. I want to by pass this "safety" feature.. anyone know the code
for it

i'm currently using this one: ActiveWindow.SelectedSheets.Delete


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=467512