VB for locking and unlocking selected cell

**cwwaicw311** · 02-02-2010, 11:17 PM

i'm new to VB and using excel to create a simple system. The system is to track inventory hence when an authorized ID is type in the ID column all the other cell will be unlock and the staff can enter the require data into the required field. So the problem is i cant manage to find VB code on locking and unlocking selected cell in excel.

**teylyn** · 02-02-2010, 11:29 PM

Hi,

you need to understand that you format a cell to be locked or unlocked with the Locked property. You will then need to protect the sheet with the Worksheet.Protect method.

You'll have to alternate between protecting and unprotecting the worksheet in your code, and change individual cells' Locked property in between.

**cwwaicw311** · 02-03-2010, 03:05 AM

I know how to lock and protect manually on the selected cell. However, i not clear on the coding for protecting and unprotecting cell.

**teylyn** · 02-03-2010, 04:14 AM

fire up the macro recorder, select a couple of cells, unlock them with the format dialog. select one or more of those cells again and lock them with the format dialog.

Stop the macro recorder and study the code. Get rid of the Select statements and take the direct approach.

Post your code if you get stuck.