Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using clear all.on different different sheet.
On one of clear all i have applied alternate state while on other did not applied but when i am using clear all (inherited state), my other default selection on clear having alternate state all is also disappearing.
can you please suggest on this
Provide sample file...
You can select Alternate State in Action tab also...!!
Hi Manish,
PFA.
I have sheet1 and she applied condition as region = all in clear button of sheet 2 so that whenever clear on sheet 2 happens it will directly shows region all but when i can apply clear on sheet 1 in my sheet 2 default selection also disappears moreover when ever i can choose region on sheet 2 region selection appears in current selection box of sheer 1 although there is no region list box.
thanks
hi all,
Can you please suggest on this.
Thanks
Hi deepak,
Can you tell the steps what would happen if we click the Sheet 1 ClearAll Button and if We click the Sheet 2 Clear All Button?
Hi,
I think it will help u to complete the task
r.click on sheet go to sheet properties
Go to triggers -> there u can see onleave sheet -> click on edit actions -> click on ADD -> under selection -> u can see the clear all -> ok ->ok -> apply -> ok
Hope it will help u.
Thank you,
Balaji.k
I am using clear all.on different different sheet.
On second sheet clear all i have applied alternate state while for first sheet did not applied but when i am using clear all (inherited state) for first sheet, my other default selection on clear having alternate state(second sheet) all is also disappearing.on second sheet Region='All' should be default.er clearing moreover region selection should not appear on first sheet's current selection box
its not working
Hi deepak,
if i understood correctly, Try this
In the first Sheet -> Clear All Button -> Give the Default State.
hi settu,
it is already in default state.
thanks