Using VBA, how can I update (write) to a locked cell in a worksheet?
T Tom Ogilvy Sep 15, 2003 #2 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.
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.
