Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locking cell | Excel Discussion (Misc queries) | |||
locking only one cell | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking a cell | Excel Worksheet Functions | |||
cell locking via VBA | Excel Programming |