prevent warning message from appearing
 

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

prevent warning message from appearing
 

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
HIS


"Tijmen" wrote in message
...
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