macro for timestamp option button

[gwallace]

I have a worksheet with more than 1 button to timestamp
the exact time. I used the function "Now()". The problem
is when i click on one of the buttons all of the functions
are updated. Is there a way to correct this?

 

[Tom Ogilvy]

With ActiveCell.Offset(0,1)
.Value = now
.NumberFormat = "mm/dd/yyyy hh:mm"
.EntireColumn.Autofit
End With

puts in a hard coded time rather than a volatile function.