Thread: locking cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dominic Dominic is offline
external usenet poster
 
Posts: 26
Default locking cell

Hello friends,
I need to create time sheets for work.. So I have created
a macro for entering the current time. But I do not want anyone to be able to
change the time once it is entered in that column. And any time entered in
the column should always be the current time

Below is my macro for current time
Private Sub cmd_time_Click()
ActiveCell.Clear
ActiveCell.FormulaR1C1 = "=NOW()"
ActiveCell.Value = ActiveCell.Value
End Sub

What do I do?