Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA: For Count, when count changes from cell to cell | Excel Discussion (Misc queries) | |||
Text formatting | Excel Worksheet Functions | |||
Help With Macro Code?? | Excel Worksheet Functions | |||
Transfer Macro code to another computer | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions |