im making a sheet where employees, after making a phonecall, hit a macro button to date/time stamp a cell. The problem being that we want these cells locked so after using the timestamp macro the employees cannot go in and alter the times.
the current macro is very simple-
//
Sub NOWTIME()
ActiveCell.Value = Format(Now(), "MM.dd h:mm AM/PM")
End Sub
//
If anyone could help it would be greatly appreciated.
currently the cells are locked and i have already passworded them
Bookmarks