Thread: Delete Sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Flemming Dahl Flemming Dahl is offline
external usenet poster
 
Posts: 11
Default Delete Sheets

Hi

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

Cheers,
Flemming


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