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"?
|