Not sure about clicking, but if you select a cell then do CTRL-SHIFT-
colon this will fix the time in that cell.

CTRL-semicolon will fix the date.

Hope this helps.

Pete

On Sep 11, 5:28 pm, jacksonsgurl
<jacksonsg...@discussions.microsoft.com> wrote:

CTRL + SHIFT + semi-colon will enter a staic time in a cell.

Another method would require event code to enter the static time when an event
takes place like a double-click on any cell.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target _
As Range, Cancel As Boolean)
    With Target
       .Value = Format(Now, "hh:mm:ss")
   End With
Cancel = True
End Sub

This is sheet event code.  Right-click on the sheet tab and "View Code".

Copy/paste into the module that opens.

If you prefer this to operate on just one column use the code below which will
enter the time into column A cells only...........

Private Sub Worksheet_BeforeDoubleClick(ByVal Target _
As Range, Cancel As Boolean)
If Target.Cells.Column = 1 Then
    With Target
       .Value = Format(Now, "hh:mm:ss")
    End With
    End If
Cancel = True
End Sub

Gord Dibben  MS Excel MVP