prevent non sequential selection

[#1]

Hi Guys,

how can i prevent from users to select non sequential selection, for instance

month dim.

1, 4, 12 - wrong

1,2,3 - ok

2 - ok

2,3,4 -ok

Thanks in advanced,

Aviad

[johnw · Accepted solution]

Attached is one solution. I trigger a macro OnSelect of the field. The maco checks the max and the min, and then makes sure that the count corresponds exactly to that range. If not, then it does an ActiveDocument.Back to undo the offending selection(s).

[#3]

Thank u !!!!