Delete Sheets

[SS]

How can I when deleting a sheet, use code to keep from
having to answer "yes" to the excel popup "The selected
sheets will be permanently deleted. ...."

Thanks

Sharon

 

[Flemming Dahl]

Hi

Application.DisplayAlerts = False
' Your delete job
Application.DisplayAlerts = True

Cheers,
Flemming

 

[Frank Kabel]

hi Sharon
try
Application.DisplayAlerts = False
' delete sheet here
Application.DisplayAlerts = True

HTH
Frank