deleting worksheet

F

Fun Kid

What line of code should I include while deleting a worksheet through
VBA so that the security feature (The selected sheet(s) will be
permanently deleted.) is disabled. Right now I have to click "OK" for
the code to continue. Any suggestions?
 
F

Frank Kabel

Hi
use something like
...
application.displayalerts=false
'delete the sheet
application.displayalerts=True
 
Top