Right click the sheet tab view code and paste the below code in the code
panel. Get back to workbook and try...Adjust the range A1 to suit your
reqirement

Private Sub Worksheet_Change(ByVal Target As Range)
Range("A1") = Now
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Gazz_85" wrote:

In a document I have I want to be able to display the last time it was
updated on the worksheet. To do this i crested a macro which copies and
pastes the =NOW() funtion into the display cell. This is simply assigned to a
command button and after an update all the user needs to do is click a button
and the last update is completed.

However this seems like to much to ask of certain people and they are
forgetting...cant be bothered to click the button so the last updated field
is wrong.

Is there a way to automate it so that whenever a field is edited (on the
entire worksheet) it auto refreshes the last updated field accordingly???

Cheers,