ActiveWorkbook.Close
 

Hi

Sub stang()
ActiveWorkbook.Close
End Sub

Is it possible to close the Workbook without get the question
if you want to save the Workbook or not?


Regards
dallas


--
dallas
------------------------------------------------------------------------
dallas's Profile: http://www.excelforum.com/member.php...o&userid=10040
View this thread: http://www.excelforum.com/showthread...hreadid=274962

ActiveWorkbook.Close
 

Hi

ActiveWorkbook.Close True ' false = not save and true = save


--
Regards Ron de Bruin
http://www.rondebruin.nl


"dallas" wrote in message ...

Hi

Sub stang()
ActiveWorkbook.Close
End Sub

Is it possible to close the Workbook without get the question
if you want to save the Workbook or not?


Regards
dallas


--
dallas
------------------------------------------------------------------------
dallas's Profile: http://www.excelforum.com/member.php...o&userid=10040
View this thread: http://www.excelforum.com/showthread...hreadid=274962

ActiveWorkbook.Close
 

Sub stang()
ActiveWorkbook.Close SaveChanges:=False
End Sub

or change it to True if you do want to save changes.

--
Regards,
Tom Ogilvy

"dallas" wrote in message
...

Hi

Sub stang()
ActiveWorkbook.Close
End Sub

Is it possible to close the Workbook without get the question
if you want to save the Workbook or not?


Regards
dallas


--
dallas
------------------------------------------------------------------------
dallas's Profile:
http://www.excelforum.com/member.php...o&userid=10040
View this thread: http://www.excelforum.com/showthread...hreadid=274962