Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Attached please find the sample file.
I am using Buttons to switch between the sheets and hidden the sheet tabs. In the attached sample I have 3 sheets Sheet03,Sheet10 and Sheet17.
Sheet 3 is triggered by Either pressing the button "SHeet03' or button "View 1", "Sheet10" is triggered by pressing button "View2".
The "Sheet03" Button has three TRiggers.
Trigger 1 "Activate Sheet - SH03
Trigger 2 " Clear All"
Trigger 3" Select in Field" . Field A, Value 2.
So When I click on "Sheet03" at top I expect all selections to clear and select value"2" in field A.
Looks like the " Clear All" works but no field selection is made.
Any idea what I am missing here ?
It works for me. No changes done.
If u click on Sheet03 twice then it works, but not the first time. User will not be clicking it twice
Try deleting those SHEET03 buttons and recreate them.