Update Excel locked cell

[Jim Carlin]

Using VBA, how can I update (write) to a locked cell in a
worksheet?

 

[Tom Ogilvy]

use the userinterfaceonly property of the protect method. When this is set
to True, the sheet can remain protected and your code can write to the
sheet.