prevent warning message from appearing

[Tijmen]

I want to remove a sheet

Sheets(2).Delete

Excel then comes up with a warning: "The selected sheet(s) will be
permananently deleted. To delete the selected sheets, click OK.To cancel the
deletion, click Cancel"

Can I somehow catch this message end prevent it from appearing?

Thanks,

Tijmen

[Nick Hodge]

Tijmen

Application.DisplayAlerts = False

Set to True at end of code or any error code that may exit the code
prematurely

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"Tijmen" <[email protected]> wrote in message
news:[email protected]...
>I want to remove a sheet
>
> Sheets(2).Delete
>
> Excel then comes up with a warning: "The selected sheet(s) will be
> permananently deleted. To delete the selected sheets, click OK.To cancel
> the deletion, click Cancel"
>
> Can I somehow catch this message end prevent it from appearing?
>
> Thanks,
>
> Tijmen
>