In,
This would require a macro to be automatically run
just before the workbook is saved.
Is that a suitable?

Jim Cone
San Francisco, USA

"In Calif"
wrote in message
...
Hi Everybody,
Is there a way to dynamcally to protect a cell after the user's input upon
saving the file? What I am looking for is to prevent users from making
changes once the file is saved after their input. I am using this to track
vacation, personal day off & sick day dates and hours taken. The users are
given a date col & hrs col to input the date, I would like the input be
protected once the file is saved but the rest of the
empty cells in the col are still unprotected for future input.

Vac Date Vac Hrs.
1/23/2005 8 (Theses entries are protected after saving the file.)
2/23/2005 4
(Blank cells in the range are left
unprotected.)

Thanks for your time and help!!!

In Calif