VB / Excell worksheet change!

[HeyFrantz]

Geff and all!
How do you check if a workbook has been changed/updated.
I am writing a procedure, but it's based on whether the workbook has been changed or not....I just can not seem to get that if condition statement right...any idea!
thanx

 

[acron]

You could use the Saved property, which his set to false if any change occurs in the workbook - e.g. :-

If ActiveWorkbook.Saved then
    MsgBox "No Change"
Else
    MsgBox "workbook changed"
End if

A.C.

 

[HeyFrantz]

that did not work: here is what I am working with:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If ActiveWorkbook.Saved = True Then
With ThisWorkbook
.HasRoutingSlip = True
With .RoutingSlip
.Delivery = xlOneAfterAnother
.Recipients = Array("heyFrantz@yahoo.com&quot
.Subject = "Updated Employee Workbook"
.Message = "The Employee workbook has been modified. Attached is a revised copy, Thanks!"
.ReturnWhenDone = False


End With
.Route
End With
End If