What is the VBA code to delete a sheet without warning message?

[slingsh0t@hotmail.com]

I have the following code to delete a tab:

Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.Delete

When I run this, I get the standard "You may lose data" warning
message. Does a different syntax allow me to delete the sheet without
getting the warning message?

Thanks

[Dennis]

Application.DisplayAlerts = False
Sheets("Your Sheet").Delete
Application.DisplayAlerts = True

HTH Dennis


"slingsh0t@hotmail.com" wrote:

> I have the following code to delete a tab:
>
> Sheets("Sheet1").Select
> ActiveWindow.SelectedSheets.Delete
>
> When I run this, I get the standard "You may lose data" warning
> message. Does a different syntax allow me to delete the sheet without
> getting the warning message?
>
> Thanks
>
>

[slingsh0t@hotmail.com]

Thanks!