Post the macro you use to enter the time.

ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM") will enter a static time.

Perhaps your macro employs event code which updates the time when something
changes.


Gord Dibben MS Excel MVP

On Thu, 13 Sep 2007 12:48:21 +0200, "Matthias Dhondt"
wrote:

Hi all,

We made a macro, to show the current time in the cell "A1", we used the
function Now()-Today()

When you adapt something in Excel, the time in cell "A1" will automatically
be changed in the current time.

What do we have to change in the macro, that the time don't adapt anymore?

greeting Matthias