Hi,

I have written the following to open up a different user form when certain
cells are changed  (The User answers "Y" to the question).  This part is
working.  My problem is when I reset the worksheet to the default values of
"N", the worksheet views this as a change and is popping up all the user
forms.  I've been trying to add the first section (which isn't working), that
if any of the cells in the range b18:p28 are changed to "N", then do nothing.

I would appreciate any help... Leslie

Private Sub Worksheet_Change(ByVal Target As Range)

   
   If Range("b14:p26").Cells = "N" Then Exit Sub
       
       
   
   If Not Intersect(Target, Me.Range("g18:g26")) Is Nothing Then
   With Target
           frmBeltBuff.Show
       End With
   End If

       If Not Intersect(Target, Me.Range("h18:h26")) Is Nothing Then
       With Target
           frmBevel.Show
       End With
   End If
   
   

End Sub