Close workbook

elgringo56 · Apr 26th, 2002, 07:19 PM

This must be a simple one. I am trying to do a Close function under macro control. The problem is that it always comes back and ask if I want to save first. I dont want to save, just close and I dont want the user to have to answer that question. I want the workbook to just go away. Is there any way to set a setting or something for this? Maybe an instruction that says close without saving? The reason I dont want to save is because I want to always start with my master workbook, all data is put elsewhere. HELP PLEASE

Tom Schreiner · Apr 26th, 2002, 07:25 PM

Hello

ActiveWorkbook.Close SaveChanges:=False

Tom

elgringo56 · Apr 26th, 2002, 07:26 PM

Damn, tom, you make me feel really dumb. I have fought that one for a while, but then, I dont profess to be a programmer. Thanks a million

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

Apr 26th, 2002, 07:19 PM	#1
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	This must be a simple one. I am trying to do a Close function under macro control. The problem is that it always comes back and ask if I want to save first. I dont want to save, just close and I dont want the user to have to answer that question. I want the workbook to just go away. Is there any way to set a setting or something for this? Maybe an instruction that says close without saving? The reason I dont want to save is because I want to always start with my master workbook, all data is put elsewhere. HELP PLEASE

Apr 26th, 2002, 07:25 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hello ActiveWorkbook.Close SaveChanges:=False Tom

Apr 26th, 2002, 07:26 PM	#3
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Damn, tom, you make me feel really dumb. I have fought that one for a while, but then, I dont profess to be a programmer. Thanks a million