Creating a spreadsheet with mandatory fields

[johnpaul1606]

Hi,

I have a spread sheet that people insist on leving cells blank! Is there vba code to make all cells mandatory?

There was this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$E$5" Then Exit Sub

If Target.Value = "" Then
MsgBox "Input required!", vbInformation + vbOKOnly, "Warning"
Target.Activate
End If
End Sub

But I want it to go from cell A2 - I2?

Please help?