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

"OssieMac" wrote in message
...
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

--