Selecting current year always only in one sheet out of many

[rsdhavle]

I have multiple sheets which has 'year' list box. I want to keep latest year selected in only one of these sheets and other sheets should not get filtered because of this.

How can we do that?

[tresesco]

Alternate State is an option.

[#3]

hi  i think by creating alternate state it is possible

[kaushiknsolanki · Accepted solution]

Hi,

     You can have a trigger for on activate sheet, where you can do the selection or deselection on required sheet.

Regards,

Kaushik Solanki

[ashfaq_haseeb]

Hi,

As tresco said, you can use alternate state.

And in that particular sheet go to Year list box properties --> and select always one selected value.

Regards

ASHFAQ

[rajat2392]

Hi Rohan,

As Kaushik said, you can right click on sheet, go to Properties>>Triggers Tab>>On Activate Sheet>>Add Action

Click on Add, then in Selection, on right side you will get an option as "Clear Field", select it, give your "Year_Field_Name" in Field name. You have to do this in all sheet you want to deselect the year.

If you want to deselect in all the sheets you have, then you can simply go to sheet properties of the sheet in which you want year to be selected.

Properties>>Triggers Tab>>On Leave Sheet>>Add Action

Click on Add, then in Selection, on right side you will get an option as "Clear Field", select it, give your "Year_Field_Name" in Field name.

Regards

Rajat