to delete a worksheet

[=?big5?B?qvykVA==?=]

but want to ignore the warning message, please advise what should I
add at the end of the following command? thanks

e.g.
Sheets("ABC").Select
Sheets("ABC").Delete

Paul

 

[Ajtb]

Hi Paul

This will work, there is no need to select the sheet first.

Sub tt()
Application.DisplayAlerts = False
Sheets("ABC").Delete
Application.DisplayAlerts = True
End Sub

Regards
Andrew Bourke

 

[=?big5?B?qvykVA==?=]

Dear Andrew

Lots of thanks!

Paul

Hi Paul

This will work, there is no need to select the sheet first.

Sub tt()
Application.DisplayAlerts = False
Sheets("ABC").Delete
Application.DisplayAlerts = True
End Sub

Regards
Andrew Bourke