password protecting cell in a protected file that are not protecte

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prtcorvette - 21 May 2008 20:17 GMT

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.

Reply to this Message

training@asgsecuritygroup.com - 21 May 2008 20:44 GMT

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
<prtcorve...@discussions.microsoft.com> 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.

Reply to this Message