Can we use a trigger only in particular sheet?

[udaya_kumar]

Hi,

i have a field, i need to write a trigger for those field.

the trigger is select in field and giving * in the value for the field.

that trigger should work only in one sheet, in other sheet, that trigger should not work.

i am using same field in the other sheet also, so there the trigger should not fire,

is there any way to do this?

[jonathandienst]

Hi

Let the trigger fire a macro. In the macro, get the active sheet name, and check against the field name for which the trigger action should take place.

Regards

Jonathan

[Michiel_QV_Fan]

Create a bookmark and select that bookmark with a trigger at the needed moment (sheet activation?).

On sheet exit the bookmark can be deselected again.