Save message before closing excel

Muratti · Apr 25th, 2002, 07:56 PM

Does anybody know how I can get rid off the "do you want to save your changes?" message, before you quit Excel?
Or how can I make it automatically say no to this message.
Thanks

Qroozn · Apr 25th, 2002, 07:57 PM

Workbooks("myworkbook.xls").Close SaveChanges:=False
(quick enough response?)

[ This Message was edited by: Qroozn on 2002-04-25 18:59 ]

NateO · Apr 25th, 2002, 08:02 PM

That was fast Q, similarily:

Code:

thisworkbook.close false

Just less typing... Good eve. (here at least) to you both.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-04-25 19:04 ]

Qroozn · Apr 25th, 2002, 08:05 PM

NateO.
I like your style.
but its midday here in Sydney.

thanks for those little tips.
they help simplify my own code.(still an XL novice)

Muratti · Apr 25th, 2002, 08:08 PM

Thanks guys.

Apr 25th, 2002, 08:02 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	That was fast Q, similarily: Code: thisworkbook.close false Just less typing... Good eve. (here at least) to you both. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-04-25 19:04 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 07:56 PM	#1
Muratti New Member Join Date: Apr 2002 Posts: 16	Does anybody know how I can get rid off the "do you want to save your changes?" message, before you quit Excel? Or how can I make it automatically say no to this message. Thanks

Apr 25th, 2002, 07:57 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	Workbooks("myworkbook.xls").Close SaveChanges:=False (quick enough response?) [ This Message was edited by: Qroozn on 2002-04-25 18:59 ]

Apr 25th, 2002, 08:05 PM	#4
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	NateO. I like your style. but its midday here in Sydney. thanks for those little tips. they help simplify my own code.(still an XL novice)

Apr 25th, 2002, 08:08 PM	#5
Muratti New Member Join Date: Apr 2002 Posts: 16	Thanks guys.