MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Entering Data in Locked Cell

  Asked By: Bryant    Date: Dec 29    Category: MS Office    Views: 1827

I am presently working in excel and my problem is. I have a protected
workbook & a protected worksheet in that book which is active. I would
like to use an user Form and capture data. after evaluating the result
I would like to update a locked cell say Cell A1 by opening the lock
and then entering a data and later locking the cell. I had been trying
to do acheive this through VBA but am unable to unlock the cell and
enter data through VBA.



3 Answers Found

Answer #1    Answered By: Alvin Nguyen     Answered On: Dec 29

I believe you want...


Do stuff


If you have a password set, add it to the code...

ActiveSheet.Unprotect "password"

Do stuff

ActiveSheet.Protect "password"

Answer #2    Answered By: Jackson Bouchard     Answered On: Dec 29

You have got my point. Thanks for the solution and I shall try it out
and keep you informed of the progress.

Answer #3    Answered By: Isaac Williams     Answered On: Dec 29

Thanks a lot I have worked out my problem  with the solution provided
by you and it is working  fine. You've hit the bulls eye. Thanks for
your help.

Didn't find what you were looking for? Find more on Entering Data in Locked Cell Or get search suggestion and latest updates.