Auto close the prompt & dialog boxes
 

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 sheet and then copy the selection, then
open another workbook to paste the data on one of the sheet. 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

Auto close the prompt & dialog boxes
 

application.CutCopyMode = False
Activeworkbook.Close Savechanges:=False


Or nest your current code in

application.DisplayAlerts = False


application.Displayalerts = True
--
Regards,
Tom Ogilvy


"HelpEachOther" wrote in message
oups.com...
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 sheet and then copy the selection, then
open another workbook to paste the data on one of the sheet. 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

Auto close the prompt & dialog boxes
 

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" wrote in message
...
application.CutCopyMode = False
Activeworkbook.Close Savechanges:=False


Or nest your current code in

application.DisplayAlerts = False


application.Displayalerts = True
--
Regards,
Tom Ogilvy


"HelpEachOther" wrote in message
oups.com...
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 sheet and then copy the selection, then
open another workbook to paste the data on one of the sheet. 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