Be gone with "Do you want to save changes made to *.xls?" me

charlie79 · Apr 8th, 2002, 09:32 AM

In an excel app I've created, I do not want the user to save changes on exit. I therefore do not want them to get the famous, "Do you want to save changes made to *.xls?" message. I've tried tricking excel and putting thisworkbook.saved = true in the workbook_beforeclose event, which seems to work, most of the time. But it seems like if the user clicks a command button that enforces the application.quit command, it ask user for save. Any ideas?

[ This Message was edited by: charlie79 on 2002-04-08 08:45 ]

[ This Message was edited by: charlie79 on 2002-04-08 08:46 ]

charlie79 · Apr 8th, 2002, 09:49 AM

It's alright, silly mistake on my part. I figured it out...

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

Apr 8th, 2002, 09:32 AM	#1
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	In an excel app I've created, I do not want the user to save changes on exit. I therefore do not want them to get the famous, "Do you want to save changes made to *.xls?" message. I've tried tricking excel and putting thisworkbook.saved = true in the workbook_beforeclose event, which seems to work, most of the time. But it seems like if the user clicks a command button that enforces the application.quit command, it ask user for save. Any ideas? [ This Message was edited by: charlie79 on 2002-04-08 08:45 ] [ This Message was edited by: charlie79 on 2002-04-08 08:46 ]

Apr 8th, 2002, 09:49 AM	#2
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	It's alright, silly mistake on my part. I figured it out...