Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I temporarily turn off messages in Excel
How do I temporarily turn off messages in Excel, i.e. "Do you want to save
changes?". I'm running a macro that opens other workbooks and copies data to my current file and then closes the other workbooks. I need to turn off warning messages, and then turn them back on at the end of the macro. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I temporarily turn off messages in Excel
Hi,
1. When you close the other books, use: Workbooks("my other book").Close False The False option explicately tells not to save, therefore no message appears. 2. For most xl messages application.DisplayAlerts=False 'turn messaging off '...code application.DisplayAlerts=true -- Regards, Sébastien <http://www.ondemandanalysis.com "jtm3001" wrote: How do I temporarily turn off messages in Excel, i.e. "Do you want to save changes?". I'm running a macro that opens other workbooks and copies data to my current file and then closes the other workbooks. I need to turn off warning messages, and then turn them back on at the end of the macro. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I temporarily turn off messages in Excel
Application.DisplayAlerts = False
do something Application.DisplayAlerts = True |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I temporarily turn off messages in Excel
Thanks, the Workbook.Close False worked great in this instance, and I'm sure
I will be using the Dispaly Alerts = False/True in the future. Thanks again! "sebastienm" wrote: Hi, 1. When you close the other books, use: Workbooks("my other book").Close False The False option explicately tells not to save, therefore no message appears. 2. For most xl messages application.DisplayAlerts=False 'turn messaging off '...code application.DisplayAlerts=true -- Regards, Sébastien <http://www.ondemandanalysis.com "jtm3001" wrote: How do I temporarily turn off messages in Excel, i.e. "Do you want to save changes?". I'm running a macro that opens other workbooks and copies data to my current file and then closes the other workbooks. I need to turn off warning messages, and then turn them back on at the end of the macro. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I temporarily turn off messages in Excel
Thanks!
" wrote: Application.DisplayAlerts = False do something Application.DisplayAlerts = True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Some data in Excel 2007 temporarily disappears. Why? | Excel Discussion (Misc queries) | |||
Possible to turn off graph refresh temporarily? | Charts and Charting in Excel | |||
Turn off Printer Messages | Excel Programming | |||
Turn off confirmation messages via VBA | Excel Programming | |||
Turn off confirmation messages via VBA | Excel Programming |