Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When ever i click the clear button , it should select some default selection.
Example when i click the clear button, correct selection should be in default selection of DEPT "IT" COLLAGE "AMIT".
please help me..
current selection shd be in default selection of DEPT "IT" COLLAGE "AMIT".
no replies
Make the selection first, then set this as "Clear State".
HIC
@ Henric .we need the clear state but filters may differs from sheet by sheet.
example.
in sheet1 if i select clear button it shd be in DEPT "IT" COLLAGE "AMIT".
in sheet2 if i select clear button it shd be in DEPT "COMP" COLLAGE "MIT".
in sheet3 if i select clear button it shd be in DEPT "ROBO" COLLAGE "ANNA".
@henric above is the example.
i think so it's not possible dirctly,
what i suggest here, create on button with Clear all (that helps to clear all ur current selections by using default ClearAll macro) and top of that button trigger another macro to perform ur default selections.
ask ur users to use this button.
Then you need to make a button with an Action or a Macro.
HIC
i have to add those functions in default clear button . not in the creattion of new button