VBA for deleting a sheet

[Mike]

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?

[Leith Ross]

Hello Mike,

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

Sincerely,
Leith Ross

[Norman Jones]

Hi Mike,

Try:

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

---
Regards,
Norman



"Mike" <Mike@discussions.microsoft.com> wrote in message
news:F3709A0A-818B-4204-9467-F98CA739645E@microsoft.com...
>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?

[Mike]

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
>
>