macro for timestamp option button
 

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?

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?