unlock a cell

  • Thread starter Thread starter Jean-Paul De WInter
  • Start date Start date
J

Jean-Paul De WInter

Hi,
What is the correct VB syntax to unlock a cell?
Thanks
 
Thanks for the reply...
However, I need to unlock cells A1 to A3 so what will be the syntax then?
Greets
JP
 
Range("A1:A3").Locked = False

the sheet has to be unprotected when you do this.
 
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

Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
unlocking cells 12
Unlock cells based on colour 2
Any fingerprint unlocks Galaxy S10, Samsung warns 11
How to unlock document in wordpad 1
Unlock based on cell colour 4
Password Cell Protection 1
Lock cell if based on value of corresponding cell 1

Back
Top