Deleting sheets with VBA
Posted by Anna DAly on December 03, 2000 9:19 AM
I have a small problem that should be quite easy to solve! I am trying to delete a sheet from a workbook using VBA code. I have succeeded in doing this with worksheet("sheet1").delete. However, it comes up with the standard dialogue box "are you sure you want to delete this sheet?" I don't want to be asked this question, I just want it to delete the sheet, and keep quiet about it. Any ideas?