I am using the following code to delete a sheet within Excel:

ActiveWindow.SelectedSheets.Delete

Problem is, it is prompting the user to see if it is okay to delete. In
every scenario of this macro, it will be okay to delete, so how can I bypass
this message?

Hi Mike,

Try:

Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True

---
Regards,
Norman



"Mike" wrote in message
...
I am using the following code to delete a sheet within Excel:

ActiveWindow.SelectedSheets.Delete

Problem is, it is prompting the user to see if it is okay to delete. In
every scenario of this macro, it will be okay to delete, so how can I
bypass
this message?

Hello Mike,

Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DispalyAlerts = True

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=487372

thanks to both of you

"Leith Ross" wrote:


Hello Mike,

Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DispalyAlerts = True

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=487372