Right now I am protecting cells with
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Const WS_RANGE As String = "D7:O7,D9:O9,D13:O13,....."
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
Application.ScreenUpdating = False
frmChange.Show
End If
End Sub
The form asks the user if they would like to change the data in the cell. If yes, it lets them. If no, it moves the focus down one row. The problem is that as a user is moving down rows using <enter> while entering data, frmChange pops up every time they come to a protected cell. My question is, is it possible to only invoke the form when the user tries to enter data into the cell instead of when the cell is selected.
Bookmarks