View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rich J[_2_] Rich J[_2_] is offline
external usenet poster
 
Posts: 38
Default How to delete Excel worksheet using VBA without delete dialog?

put this line in front of your group of code that deletes the worksheet

Application.DisplayAlerts = False

then put this after

Application.DisplayAlerts = True

I think that should take care of it.



"cocalico22" wrote:

In my VBA macro, I delete a worksheet. A dialog displays asking if I really
want to delete the worksheet. The answer is always yes therefore I do not
want the user to have to click the Delete button so the macro can continue.
Is there any way to turn off this "feature"?