Saving
 

How can I make a workbook close without prompting to save?
This file has many links to other workbooks, and it has many viewers.

Thanks


--
DRANDON
------------------------------------------------------------------------
DRANDON's Profile: http://www.excelforum.com/member.php...o&userid=35901
View this thread: http://www.excelforum.com/showthread...hreadid=566107

Saving
 

I take it that you do NOT want changes saved. If that's right, enter
this code in the ThisWorkbook module. James

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub


DRANDON wrote:
How can I make a workbook close without prompting to save?
This file has many links to other workbooks, and it has many viewers.

Thanks


--
DRANDON
------------------------------------------------------------------------
DRANDON's Profile: http://www.excelforum.com/member.php...o&userid=35901
View this thread: http://www.excelforum.com/showthread...hreadid=566107