View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pokey* Pokey* is offline
external usenet poster
 
Posts: 2
Default WorkSheet.Delete

I've run into a problem about deleting sheets. I wrote
a "work around" whereby the unwanted sheet is moved to a
new workbook and the new workbook is closed without
saving it, but I just think there has to be a better way!

If I use VB to delete a worksheet, I do not know how to
prevent the system from asking to confirm delete. This
same message appears when you manually delete, by the
way. Does anyone know how to answer (or prevent from
showing) that message box using VB?

Thanks!