trigger miss firing when i press clear all button

[kunkumnaveen]

Hello All,

I wrote a trigger  (activate sheet to sheet2)    on a filed (material name) so that it will bring me to next sheet(sheet2) which is working fine. the problem is,  suppose from sheet2 if I move to another sheet(sheet3 or any)  without clearing the selection and clearing it over there after moving then it bringing me back to sheet2 from the other sheets which is not good ,so what I am looking if I clear it  in other sheet it should stay in the same sheet  should not bring back to sheet2.

can any one suggest if it possible to achieve without changing trigger option ,because i need trigger

[Kushal_Chawda · Accepted solution]

Go to Sheet 2-> Go to sheet Properties -> Trigger -> On leave sheet -> set the clear Field or clear all trigger

[Chanty4u]

ddi u try Onleave sheet trigger ?

[Chanty4u]

Hi,

PFA

Sample