"Do you want to save changes?" question

[Robert Crandal]

Is there a flag or variable or property that I can check
that indicates whether or not the "Do you want to save
changes?" dialog will appear when a workbook is closed??

If someone changes the contents of a cell and tries to close
the workbook without saving, Excel knows that the user
did not save the workbook. So, just to be more clear,
how can I find out if Excel knows that a "save changes"
is required??

thank you

 

[JLGWhiz]

More than one option.

Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True

Or:

ActiveWorkbook.Close SaveChanges:=False

 

[Robert Crandal]

I don't think that was what I was looking for..... I think
maybe I worded my original question inaccurately, so
I'll try again:

How can I know if Excel WILL display the "Save changes"
dialog box when a user tries to close the workbook???

Here is my current psuedo-code that will be run when
a closer tries to close the workbook:

If 'Excel WILL show "Save changes" box' then
MsgBox "Here comes dialog box"
else
MsgBox "You wont see "Save changes" box
end if

Does that make sense??

 

[OssieMac]

Hi Robert,

I interpreted you question a bit differently to JLGWhiz and now not sure
that my interpretation is correct but I'll post my answer anyway. (Straight
out of Help.)

If Not ActiveWorkbook.Saved Then
MsgBox "This workbook contains unsaved changes."
End If

 

[OssieMac]

Hi robert,

The code I posted should do that for you but perhaps it had not shown itself
before your reply so here it is again inserted in your example.

If Not ActiveWorkbook.Saved Then
MsgBox "Here comes dialog box"
Else
MsgBox "You wont see Save changes box"
End If

 

[Robert Crandal]

Thank you.... that's what I was looking for! 8)