Hi,
We have a scenario where we are trying to exclude some values from a Dashboard depending on who is opening it. We set the value for who is opening it on open and this is correlated with a list of Excluded Values (EXCLUDED_KEY). I want to take this set of excluded values and use it to exclude a selection in another field (MAIN_KEY) so that these values are available to some users, but not others.
I have been trying to do this in a macro by selecting all values in EXCLUDED_KEY and then making this selection in MAIN_KEY and selecting excluded from there. This works when there is only one value to be excluded, but does not work for multiple selections.
excluded = ActiveDocument.Evaluate("EXCLUDED_KEY")
ActiveDocument.Fields("MAIN_KEY ").Select(excluded )
ActiveDocument.Fields("MAIN_KEY ").SelectExcluded(excluded)
I have also been looking into doing this with an array, but am struggling to get this to work and am inexperienced in using them.
If I were to set up an array using the following, could I use this to make selections in MAIN_KEY?
vArray = Split(EXCLUDED_KEY, ",")
Thanks,
Charlie
