Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having a hard time trying to maintain a selection across sheets and back. Any suggestions on things to look at?
Thanks
~Norman Rea
The main sheet has a OnActivate trigger that Clear All selections.
Right click on the sheet tab, and select Properties.

can you explain what exactly you are looking for .. and what issue you are facing.
I am trying to put month and year dialogs on all sheets and want to maintain the selection across the pages. I can't seem to get it to keep the selection when you click on the other tab (sheet) and back.
~Norm
If you selections is not the same one two different sheets, look in the following areas.
- Sheet level trigger that alters selection
- Alternate states that make sheets or object show selections form different states
- Set expressions that lead to data from a different selection to show
If this does not help, please provide more details like screenshots or sample QVW.
Here is the sheet. If I make a selection and go to sheet one everything is good. When I go back to the original sheet it erases my selection.
~Norm
The main sheet has a OnActivate trigger that Clear All selections.
Right click on the sheet tab, and select Properties.

Thank, I dont know how I missed that
~Norm