If you use John's circular reference method you don't need macros enabled.

That method is posted above the worksheet_change event method.


Gord Dibben MS Excel MVP

On Wed, 29 Oct 2008 07:18:10 -0700, jen2018
wrote:

Thanks but even with the formula option it only works when I have my macros
on. Is there a way round this?

"Niek Otten" wrote:

Look he

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jen2018" wrote in message
...
Hi

Is there a way to insert the current date into a cell in column D when a
cell on the same row is changed?

I need a method that doesn't involve a macro as many people will be
updating
the spreadsheet and won't enable their macros