Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dialog prompt during opening of file | New Users to Excel | |||
How do I prompt a user with a dialog box | Excel Programming | |||
How Close Excel from CMD prompt? | Excel Programming | |||
Automatically Close Dialog Boxes | Excel Worksheet Functions | |||
Save Changes Prompt at close | Excel Discussion (Misc queries) |