This content has been marked as final. Show 3 replies
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