Changing Cell Value on Save

[kasperblue]

Hello,

I have various worksheets within my workbook. On sheet 1 I have a cell (H7) which is called "Change Date".

Does anyone know how to change this date when the workbook (any sheet) is edited in any way?

Thank you

[lausianne]

http://support.microsoft.com/kb/213612/en-us

... but do you really want to do that?
-> "Note, however, that you should not call macros unnecessarily because they slow down the performance of Excel."

Perhaps you could add a button to update the date?

I'm using something similar. The sheet is updated whenever it is activated:

Please Login or Register  to view this content.

[kasperblue]

Thanks - I understand you thoughts about unnecessary macros, however this is going to be used as a record of changes, just in case the user forgets!