I have an excel workbook that is a form for assigning part numbers. The form
has password protection on all cells except the ones the user wants to
fillin. I want to know if the is a way or a macro to password protect (lock
typed data in these fields) after the user fills them in and is saving and
closing the file? using excel 2003 SP2.

Not entirely getting what you are trying to say from your message
here, but from what I do get, have you looked at using Data
Validation? It's relatively easy to learn and setup and is a great
feature to have knowledge of.

After re-reading your message, I think you are in need of a macro that
upon users entering information into the cell, the macro will transfer
this information to a "holding" area or sheeet. Maybe some more
explanation or example?

HTH

-Imonit


On May 21, 3:17*pm, prtcorvette
wrote:
I have an excel workbook that is a form for assigning part numbers. The form
has password protection on all cells except the ones the user wants to
fillin. I want to know if the is a way or a macro to password protect (lock
typed data in these fields) after the user fills them in and is saving and
closing the file? using excel 2003 SP2.