Re: Auto close the prompt & dialog boxes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

As originally stated:

Application.CutCopyMode = False

clears the clipboard if it holds a range copied from Excel.

or to suppress the prompt

Application.DisplayAlerts = False

' code that would produce a prompt

Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


"Tom Ogilvy" <twogilvy@xxxxxxx> wrote in message
news:%23LWDf4aBGHA.984@xxxxxxxxxxxxxxxxxxxxxxx
> application.CutCopyMode = False
> Activeworkbook.Close Savechanges:=False
>
>
> Or nest your current code in
>
> application.DisplayAlerts = False
>
>
> application.Displayalerts = True
> --
> Regards,
> Tom Ogilvy
>
>
> "HelpEachOther" <kwright@xxxxxxxxxx> wrote in message
> news:1135113021.889035.265660@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Hello, Excel Experts:
> >
> > I need help to auto close prompts & Dialog boxes for saving change. My
> > program opens one
> > workbook, sort the data on one *** and then copy the selection, then
> > open another workbook to paste the data on one of the ***. My
> > problem is that the excel won't let me close the first workbook without
> > showing two dialogue boxes- one is asking is the user if he wants to
> > save the change before closing the book, another dialog box is asking
> > the user if he wants to save or clear the data in the clipboard. For
> > both message, the user should click the "no" button. I want to write
> > some code to close these dialog boxes automatically or prevent them to
> > appear.
> >
> > I have tried to run some Micros to see if it will show me the code, but
> > no success. Does anyone know how to do that? I really appreciate any
> > help or suggestions. Thank you very much.
> >
> > KHW
> >
>
>


.

Quantcast