password protecting cell in a protected file that are not protecte

[prtcorvette]

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.

 

[training]

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