password protecting cell in a protected file that are not protecte

  • Thread starter Thread starter prtcorvette
  • Start date Start date
P

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change cell color in protected sheet 1
Password protected macro 3
protecting cells by password 2
vba solution for protection 3
Word Macros in a Protected Word Document 0
Password for cell protection within VBA 1
allow a user to edit ranges in a protected worksheet 3
Multi worksheet protection & editing ability 6

Back
Top