deleting a sheet in Excel 2000

  • Thread starter Thread starter jerry chapman
  • Start date Start date
J

jerry chapman

When I delete a sheet in Excel a pop up window appears asking if I really
want to delete it. Is there a way to cause that window not to appear, and
delete the sheet without asking the question?
 
Jerry,

Mine deletes without the dialogue box so there has to be a way. I have
looked in OPTIONS but can find no reference on how to change it.

BUT it can be done. Good luck
 
Hi
solution in VBA
'...
application.displayalerts=false
'delete the worksheet
application.displayalerts=true
'...
 
Back
Top