Processing
 

Excel - locking remainder of row based on cell value

30/08/2016 18:25#1

Joined at: 4 months ago

Post: 1

Thank: 0

Thanked: 0

I've seen a number of posts with similar goals but not quite the complexity I'm looking to accomplish. I should also say, while I have some coding experience, I'm not very good with VB (I can usually muddle my way through a section of code to understand what it does, writing my own is tougher)

Using Excel 2013 on Windows 7...

I have several columns, but only one/couple of which should be documented in based on the value chosen in a previous column.

User selects one value from "Problem"/"Goal"/"Intervention" custom data validation list in row 1 of Column A.

  • If Problem is selected, row 1 of column B should be documented in and row 1 of columns C,D,E & F should be locked.
  • If Goal is selected in R1,CA, then column C should be documented in and row 1 column B,D,E & F should be locked.
  • If Intervention is selected in R1,CA then Row 1, column B & C should be locked and D,E & F should be unlocked to document in.

This logic should then propagate down for each row.

I was working with this code segment which performs a similar function but doesn't address the complexity I'm looking for. Any help would be greatly appreciated.

Private Sub Worksheet_Change(ByVal Target As Range)     If ActiveSheet.Cells(2, 7).Text = "X" Then         ActiveSheet.Range(Cells(3, 7), Cells(66, 7)).Locked = True     Else         ActiveSheet.Range(Cells(3, 7), Cells(66, 7)).Locked = False     End If End Sub 

Thanks in advance.

Similar articles

Excel More conditions in one formula?

4 months ago - Reply: 2 - Views: 171

Get Workbook reference from Open File dialog

4 months ago - Reply: 2 - Views: 128

Add Calculated Field To Pivot Table

4 months ago - Reply: 0 - Views: 5

Nested IF Functions in Excel not working

4 months ago - Reply: 3 - Views: 163

Formulating Date in Excel 2013

5 months ago - Reply: 2 - Views: 88

VB6 extracts in Excel 2013

5 months ago - Reply: 2 - Views: 153

Excel 2013 : Pull Matching Data from Column

5 months ago - Reply: 1 - Views: 19

excel search and copy in/from another file

5 months ago - Reply: 0 - Views: 1

Buggy PivotTable.ColumnRange

5 months ago - Reply: 0 - Views: 4

Excel static conditional formatting area

5 months ago - Reply: 0 - Views: 8

vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re