macro for timestamp option button
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.
--
Regards,
Tom Ogilvy
"gwallace" wrote in message
...
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?
|