S
Shu of AZ
In a macro I have, I first clear the data then delete a worksheet named
Decision and the macro stops and asks for user input by displaying a dialog
box that asks for a response with an OK via mouse click on the DELETE button
or a CANCEL.
Is there code that will press the DELETE button automatically and avoid the
stoppage?
Here is the code that exist currently.
Sheets("Decision").Select
Application.CutCopyMode = False
Cells.Select
Selection.Clear
ActiveWindow.SelectedSheets.Delete
Thank you
Decision and the macro stops and asks for user input by displaying a dialog
box that asks for a response with an OK via mouse click on the DELETE button
or a CANCEL.
Is there code that will press the DELETE button automatically and avoid the
stoppage?
Here is the code that exist currently.
Sheets("Decision").Select
Application.CutCopyMode = False
Cells.Select
Selection.Clear
ActiveWindow.SelectedSheets.Delete
Thank you