Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disabling Excel pop-up dialog boxes
I'd like to know how to close a spreadsheet unconditionally without incurring
a saving dialog popup box (that requires operator input). I believe it can be done using VB, and I'd like to know how to do this; if there is a way to manually configure Excel when I first open Excel (2003), this may also work. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disabling Excel pop-up dialog boxes
There is no setting in Excel for this. The only approach I can think of is
to set an application level event handler (in an add-in I think) that intercepts the Before_Close event of all workbooks and sets their Saved property to True. Chip Pearson has a page describing application event handlers: http://www.cpearson.com/excel/AppEvent.htm -- Jim Rech Excel MVP "John" wrote in message ... | I'd like to know how to close a spreadsheet unconditionally without incurring | a saving dialog popup box (that requires operator input). I believe it can | be done using VB, and I'd like to know how to do this; if there is a way to | manually configure Excel when I first open Excel (2003), this may also work. | Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disabling Excel pop-up dialog boxes
Try:
Application.Quit Application.ActiveWorkbook.Close savechanges:=False HTH, Gary Brown "John" wrote: I'd like to know how to close a spreadsheet unconditionally without incurring a saving dialog popup box (that requires operator input). I believe it can be done using VB, and I'd like to know how to do this; if there is a way to manually configure Excel when I first open Excel (2003), this may also work. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repost: Disabling Update Links dialog box | Excel Discussion (Misc queries) | |||
Disabling Update Links dialog box | Excel Discussion (Misc queries) | |||
Dialog Boxes for Excel Program | Excel Programming | |||
Dialog boxes in Excel | Excel Programming | |||
DIsabling Escape Key while dialog active | Excel Programming |