Delete Sheets

S

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
 
F

Flemming Dahl

Hi

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

Cheers,
Flemming
 
F

Frank Kabel

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

HTH
Frank
 
Top