macro for timestamp option button

  • Thread starter Thread starter gwallace
  • Start date Start date
G

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?
 
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.
 
Back
Top