Delete Sheet Prompt

[Herman Merman]

Hi,

I've written a macro which copies data over from a worksheet and then
deletes the original worksheet. The problem is the warning associated with
the deletion of a sheet interupts the running of the macro and resumes once
the 'delete' option is selected.

Any way I can tell the macro to delete the sheet without the prompt?

 

[Don Guillett]

try application.displayalerts=false
your code
reset to true

 

[Frank Kabel]

Hi
try something like
sub foo()
'...
application.displayalerts = False
' delte the sheet
application.displayalerts = True
'...
end sub

 

[Robin Hammond]

Herman,

try this

application.displayalerts = false
'your code
application.displayalerts = true

Robin Hammond
www.enhanceddatasystems.com