Hi

I am starting to believe that there is no answer, to force a no save!

I need the opposite to Application.SaveWorkspace, so the "Do you want to
save..." dialogue doesn't appear on exit.

As you can tell, I don't want changes made to the workbook, or even the
choice given to people as they exit. Can anybody help me?

Rich


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

add this into your workbook:


Code
-------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Su
-------------------



cheers,
gopp

--
Gopp
-----------------------------------------------------------------------
Goppi's Profile: http://www.excelforum.com/member.php...fo&userid=1582
View this thread: http://www.excelforum.com/showthread.php?threadid=27314