Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
close excel without saving
I have inserted various code(s) in vbs "this workbook" using private sub
auto_close and private sub work_book close() after other code to close excel/workbook without saving or displaying a prompt but none seems to work. I have used 'application.displayalerts = false'.' application.quit', 'thisworkbook.close savechanges:=false' etc etc in a variety of different combinations. Perhaps I am placing the code in the wrong place or perhaps I should be saving before quitting or ..... ? Can anyone help ? Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code to close an excel sheet without saving it .(via msgbox) | Excel Worksheet Functions | |||
Am i the first person to close and excel file, without saving chan | Excel Discussion (Misc queries) | |||
Excel 2003: File->Close without saving changes (save menu does no. | Excel Discussion (Misc queries) | |||
Open/Close Event and Excel Saving process | Excel Programming | |||
Auto close excel without saving | Excel Programming |