Update Excel locked cell
 

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

Update Excel locked cell
 

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.

--
Regards,
Tom Ogilvy

"Jim Carlin" wrote in message
...
Using VBA, how can I update (write) to a locked cell in a
worksheet?