Triggers on SheetActivation

[maxime66]

Hi Qlikers

i've created a list of my Sheets Name and i check changes on the filed "onglet" to activate the selected sheet.

(Properties Of document / Triggers / Triggers for events on a field)

This part works well.

I also set a trigger on "RDV" sheet to select specific salesman.

When sheet "RDV" is selected i want "salesman" = "jon" (that works manually but not with the sheet list method below)

any ideas to fix this?

thx by advance.

[maxime66]

Hi,

i find another way (without modifying my sheet triggers)

Document Properties / Triggers / Field event triggers /  field <onglet> / OnSelect / Execute macro : theFieldValues)

Sub theFieldValues

ActiveDocument.Sheets(ActiveDocument.Fields("id_onglet").GetPossibleValues.Item(i).Text).Activate

end sub

Works fine ! (as long as Qlik keeps Vba module in their plan )

Regards

Max.