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,