Deleting Worksheet

S

shimeel

Hello..

When in a macro, i delete a worksheet, it pops up a message asking fo
confirmation to delete the worksheet.. is there any way i can stop tha
message from coming up and delete it ... ?


shimee
 
F

Frank Stone

hi
Application.DisplayAlerts = False
Worksheets("yourworksheet").Delete
Application.DisplayAlerts = True

when you turn alerts off, be sure to turn them back on
again.
Regards
Frank
 
Top