OnActivateSheet trigger overwrites selection made via mouse
The customer's tab is using the Select in Field action on the OnActivateSheet Event Trigger, returning a set of data >=0 for a financial value.
The issue is that when they attempt to select a set of data, for example drawing a box around a pie-graph slice, the Trigger re-selects data and overwrites the user selection.
For example, they want to see sales from $10 - $20 in the graph, select it and if the Trigger is present it re-selects (not all) data outside of the $10 - $20 range they tried to capture with the mouse selection.
Is there a way to have the Trigger apply without interferring with selections made by the user?
I have found the Lock All trigger which is also in the OnActivateSheet, is the culprit. Removing it allows a user to make a selection and still filter on data with the other Trigger.
