DisplayAlerts = False. Don't forget to reset to = True.

Ed

"Rob" wrote in message
...
Hi,

I am writing a VB macro for Excel 2000 and a step in it
deletes a worksheet in the file. When macro runs during
this step a dialog or message box appears stating
that 'Selected Sheet will be permanently deleted, OK,
Cancel.' If user selects 'OK' the macro continues but if
they hit 'Cancel' the macro fails.

Does anyone know of if it is possible to write a code so
that this dialog box does not appear? Or any other way
to bypass it?

Thanks for any assistance/advise