Hi, yes it is possible. Place this in the sheet module for the
worksheet you want to check for 'Y' value:

Private Sub Worksheet_Change(ByVal Target as Range)
'Test to see if change ocurred in Cell 'B2'
If Target.address(0,0) < "B2" Then exit sub
'Test if Cell B2 = "Y"
If Target.value = "Y" Then Call MacroX
End Sub

HTH-Lonnie M.