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.