Only with VBA,
Hit Ctrl an F11 to open the
VB editor, double click 'This Workbook' and copy
and paste this code into it,
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
ThisWorkbook.Saved = True
End Sub
Bear in mind that if someone opens the workbook with macro's disabled they
can do as they wish. There are ways to overcome that too, but Excel
protection of all kinds is weak and can be easily circumvented.
Regards,
Alan.
"Shariq" wrote in message
...
I couldn't find anything in this regard on help menu, but if it is possible
in excel, I'd like to know if I can make a book which when closing
shouldn't
ask for save changes or is it really not possible, I'd appreciate any
replies
in this regard.
SHARIQ
thanks in advance