always one selected option removing and asigning for listbox

[Anonymous]

Hi All,

              i have 2 sheets in dashboard in sheet1 quarter field selected as default one option and when i move to next sheet2 the 'always one selected' option is clearing and when coming back to sheet1 'always one selected' option is asigning to listbox by using on sheet active and on sheet leave events in sheet properties, but when i use same functionality for month field in sheet2 it is not working in both sheets ,please suggest me the best way to active this. i used macro in sheet active and sheet leave events.

please give me a solution for this.

[#2]

please use buttons concept instead of macro.

try to use sheet actions( on activate and on leave sheet)

[adamdavi3s]

I've just been messing with this and I think its some sort of timing issue... the macro isn't finishing before the clear field or something crazy

I'll keep playing

[adamdavi3s]

How do you change the 'always one selected' without a macro then?

[adamdavi3s]

Yeah it works if you put the month selection in the macro...

[Anil_Babu_Samineni]

You may need like below. I am done without Macro. In fact, I don't like to use Macros it kills the performance on AJAX Browser

PFA

[adamdavi3s]

You don't have always one selected value activated.....

[Anil_Babu_Samineni]

It is there, When you back to SH01 from SH02.

[adamdavi3s]

I can select multiple options

[annafuksa1]

I have change your macro and now is working

only one think is you need to choose the same time frame (like in example Nov-Q4- you can add one more trigger and change it to Q1)

Anna