deleting worksheet

[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?

 

[Frank Kabel]

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

 

[Fun Kid]

Hi Frank,

Thank you for your prompt reply. It worked.

Fun Kid