conditional locking and unlocking of column cells

**d.archana5** · 01-07-2009, 03:53 AM

Hello,

I want to create a table in excel,such that

if there are 3 columns(a,b,c) then

if data is entered in cells of column A then cells in column's B and c should be locked.

If data in cells of column A is deleted or if the cell's in A are empty then columns B and C should be unlocked.

can some one tell me how to do this.

**royUK** · 01-07-2009, 04:50 AM

Try this

Please Login or Register  to view this content.

This code uses a Worksheet event and is stored ion a worksheet module. To add it to your worksheet, do the following:

Copy the codee
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

**d.archana5** · 01-08-2009, 05:22 AM

Hey ,

thanks a lot for your help.

but the code is not working.

Copied the code into the worksheet the way its mentioned and saved it.

After saving it ,opened sheet 1 and entered data into Cells of columns A.

columns B,C are not getting locked.

I even tried the code protecting the sheet.

its not working ,do i need to do any more steps before executing the code.

**royUK** · 01-08-2009, 05:28 AM

By default all cells in a worksheet are locked. You need to first unlock all cells

Format->Cells->Protection then clear the locked box

conditional locking and unlocking of column cells

LinkBack

Thread Tools

Rate This Thread

Display

conditional locking and unlocking of column cells

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions