View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob[_16_] Rob[_16_] is offline
external usenet poster
 
Posts: 2
Default Deleting Excel Message/Dialog Boxes

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