Update Excel locked cell

  • Thread starter Thread starter Jim Carlin
  • Start date Start date
J

Jim Carlin

Using VBA, how can I update (write) to a locked cell in a
worksheet?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Edit Locked Cells with UserForm only 1
Allow VBA code to change a locked cell?? 2
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Locking and Unlocking Cells via VBA 3
Locked cells 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel VBA 0
2003 & 2007 Differences in Locking Cells Syntax 5

Back
Top