Limit a cell to except a function only.
I don't think you can do this.
Maybe you could lock the cell, protect the sheet and then give the users a macro
to fill the activecell with the current time (and date??).
Your code may have to unprotect the worksheet, do the work and then protect the
worksheet.
But be aware that worksheet protection is easily broken.
Jim wrote:
I am attempting to block all manual entries frm being placed in a range of
cells used for time keeping. I want to force all users to use the
"ctrl,shift,;" command only to ahave a time placed in the cell, but not allow
them to manually type in the times.
Any Assistance will be greatly appreciated!
--
Dave Peterson
|