change
SelectionChange
to
Change

would be the easy answer, but I suspect the code your not showing unprotects
the sheet. So I think your code will require a lot more work to manage
that.

--
Regards,
Tom Ogilvy

"Prometheus" wrote
in message ...

Right now I am protecting cells with

Code:
--------------------

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.


--
Prometheus
------------------------------------------------------------------------
Prometheus's Profile:
http://www.excelforum.com/member.php...o&userid=15697
View this thread: http://www.excelforum.com/showthread...hreadid=473397