Macro, fields and trigers

[shayraber]

Hi all,

I'm working with QV forfew month now and I have 2 questions, please:

1. Lets assume I have a model with a field in a list box with 3 values: aaa, bbb, ccc.

I want to prevent the user from choosing all three values at this field.

Choosing each value by itself is valid choice, choosing aaa + bbb is also valid BUT

Choosing aaa + bbb + ccc OR choosing bbb + ccc are both illegal.

2. I have a bar chart where the dimension is month. I want that by clicking on one of the bars at the graph

(Which represent a month) that not just the selected month will be marked a chosen BUT also a different sheet

Will be activated. Since a field triger exists only at the document level and i don't want that each time

That a month is chosen at an other object that the specified sheet will be activated BUT only at a certain chart.

Please assist,

Thanks and Best Regards,

Shay