Global changes to 'Hide Excluded'

[#1]

My users are split exactly 50/50: half want to see the excluded selections in list boxes, and half prefer the greyed-out view with no text for selected items.

Is there a way of changing this option globally for the whole model, or do we have to iterate through all the list boxes? I can't see this as a global setting in the Document Properties.

As a general question, where is this sort of thing documented? There's some in the Tech Ref but it's quite limited.

Thanks,

Prune.

[marcus_sommer]

You could set these user-depending  - if(osuser() = ... - per macro triggered by any event. See APIGuide.qvw for examples like this:

set LB = ActiveDocument.GetSheetObject("LB01")

set box=LB.GetProperties

box.Layout.ExcludedValuesMode = 1

box.Layout.HideExcluded = true

LB.SetProperties box

- Marcus