Delete a Worksheet

  • Thread starter Thread starter carlos.cruz
  • Start date Start date
C

carlos.cruz

Hi,

How can I delete a worksheet in excel without the prompting window?

Thanks

Carlos Cruz
 
You need to use VBA, Access the WorkSheets collection and Call Delete method there.

Hi,

How can I delete a worksheet in excel without the prompting window?

Thanks

Carlos Cruz
 
Hi Carlos,

Assuming that you just want to know about the prompt disabling, and not
about the deletion, you could give this a go.

oExcel = New Excel.Application
oExcel.DisplayAlerts = False

Or do you need to know about deleting as well?

Regards,
Fergus
 
Back
Top