Deleting Worksheets Within A Macro

J

Jennifer Graham

I have recorded a macro which deletes worksheets. When I
got the prompt asking me if I was sure I wanted to delete
the sheets, I pushed 'OK', however this step does not show
up in the macro I recorded. When I run the recorded
macro, it stops to prompt me if I am sure. How do I
automate this step directly into the macro?
 
F

Frank Kabel

Hi
enclose the deletion statement with
application.displayalerts=false
'your code
application.displayalerts=True
 
Top