Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.