Re: Macro code

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Shu

Selection.Clear
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True



Gord Dibben MS Excel MVP

On Mon, 29 Jan 2007 09:42:01 -0800, Shu of AZ
<ShuofAZ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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

.

Relevant Pages

  • Ignore F1-F12 keys when user enters text input on console
    ... The user input it taken using STDIN.getc. ... the entered characters are not displayed and each character is ... obscured by displaying an asterix. ... def TestFunc ...
    (comp.lang.ruby)
  • Re: Textbox control question
    ... I am using a textbox control on a form, to accept user input. ... I will be displaying a prompt ">" at the begining of the last line, ...
    (microsoft.public.vb.general.discussion)
  • Re: Re-enable Recent Files" Lists in all programs
    ... Gord Dibben MS Excel MVP ... file so that none of my programs have the ability to display their "Recent ... Files" lists from the "File" menu. ... displaying the list is grayed out in programs such as Word, Excel, etc. ...
    (microsoft.public.windowsxp.general)
  • Re: Re-enable Recent Files" Lists in all programs
    ... Gord Dibben MS Excel MVP ... Files" lists from the "File" menu. ... displaying the list is grayed out in programs such as Word, Excel, etc. ... I want to see my recently opened files in all my programs. ...
    (microsoft.public.windowsxp.general)
  • Re: Break and Resume?
    ... What about displaying a page with problems and asking for solutions and when ... bad reasoning is to try to interleave processing and asking for user input ... "Ron Bell" a écrit dans le message de ...
    (microsoft.public.dotnet.framework.aspnet)