Putting the following line of code near the top of your module will stop all
warning boxes from appearing:

Application.DisplayAlerts=False

Then at the end, place:

Application.DisplayAlerts=True

HTH
Mike

--
Michael J. Malinsky


"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