I have the following code:

Private Sub Workbook_Open()
Worksheets(1).Range("A1").Value = Now()
End Sub

This shows current date and time but i only need it to change if workbook is
modified. This code will be within a workbook that is sent from one country
to another and needs to maintain its orginal timestamp.Can this be done?