Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove the default,"Do you want to save changes made to xxx.xls?"
I am trying to remove the default question, "Do you want to save changes made
to xxx.xls?" when I leave any excel worksheet. Thank you, John J. Donadio |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove the default,"Do you want to save changes made to xxx.xls?"
Hi John:
Enter this macro: Sub fast_quit() Application.DisplayAlerts = False Application.Quit End Sub and assign a short-cut key to it. If you run the macro, it will quit Excel without the warning. Be Careful -- Gary's Student "Philly Flash" wrote: I am trying to remove the default question, "Do you want to save changes made to xxx.xls?" when I leave any excel worksheet. Thank you, John J. Donadio |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove the default,"Do you want to save changes made to xxx.xl
Sorry, but I do not know how to create an excel macro. I tried but kept
running into problems. Could you be more specific. I do know how to get to the macro creator (tools, record a macro) but that's about as far as I get. I tried cutting and pasting the info you gave. "Gary''s Student" wrote: Hi John: Enter this macro: Sub fast_quit() Application.DisplayAlerts = False Application.Quit End Sub and assign a short-cut key to it. If you run the macro, it will quit Excel without the warning. Be Careful -- Gary's Student "Philly Flash" wrote: I am trying to remove the default question, "Do you want to save changes made to xxx.xls?" when I leave any excel worksheet. Thank you, John J. Donadio |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove the default,"Do you want to save changes made to xxx.xl
Using macros is easy. See:
http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary's Student "Philly Flash" wrote: Sorry, but I do not know how to create an excel macro. I tried but kept running into problems. Could you be more specific. I do know how to get to the macro creator (tools, record a macro) but that's about as far as I get. I tried cutting and pasting the info you gave. "Gary''s Student" wrote: Hi John: Enter this macro: Sub fast_quit() Application.DisplayAlerts = False Application.Quit End Sub and assign a short-cut key to it. If you run the macro, it will quit Excel without the warning. Be Careful -- Gary's Student "Philly Flash" wrote: I am trying to remove the default question, "Do you want to save changes made to xxx.xls?" when I leave any excel worksheet. Thank you, John J. Donadio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save changes when no changes made | Excel Discussion (Misc queries) | |||
File Save although no changes were made | Excel Discussion (Misc queries) | |||
Excel2000 keeps asking me to save when no changes were made | Excel Discussion (Misc queries) | |||
Save prompt when no changes made | Excel Discussion (Misc queries) | |||
i made change in a current workbook and accidentally save it, can. | Excel Discussion (Misc queries) |