Simple but complex code

[ivbacol]

Hello all,

I am getting more and more familiar with VBA. Since I took some courses on Java I felt quite comfortable with my level of knowledge, until I had to combine different functions.

Bottom line I am looking for:
Upon a decimal number is entered, to be validated to fall between a range; if out of this range for the cell to turn red.
Regardless if out or not of this range to lock the cell.

I have coded so that it saves and protects upon exiting, can I also lock all other cells previously populated, several users will be using this spreadsheet.

I have been able to get very helpful bits from this forum, still I have not been able to put it together. Any suggestion is greately appreciated.

 

[jproffer]

What are you trying to put together......In other words, what DO you have so far?

 

[ivbacol]

This is what I have in my module1

Sub auto_open()
ThisWorkbook.Sheets("Sheet1").OnEntry = "Validation"
End Sub

Sub Validation()
Dim isect As Excel.Range
Set isect = Range("C12:C20")
If isect.Value = 0 Then

Else
If (Val(ActiveCell.Value) < "$D$5" _
Or Val(ActiveCell.Value) > "$F$5") Then
ActiveCell.Interior.ColorIndex = 3
End If
ActiveCell.Locked = True
End If
End Sub

Many thanks!