right click sheet tabview codeinsert this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("ifrng")) Is Nothing Then MsgBox "Yes"
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
ps.com...
I have a named range and when a user selects a cell I want to see if
their selection is inside that range. Any ideas?