Delete Sheets
 

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

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

Delete Sheets
 

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

HTH
Frank


SS wrote:
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