Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 set of filters
1.CalYear and CalMonth
2.AsofYear and AsofMonth
and I have 2 buttons if I select 1stbutton calyear and calmonth will be visible
if I select 2nd button asofyear and asofmonth will be visible
but all these filters will be having always one value selected
so now I want to clear asofyear and asofmonth when 1 button is selected and calyear and calmonth should be cleared when 2 button is selected
this is possible if we don't have always one value selected but I want this with always one value selected
any idea..
Thanks in advance
A macro like below can do so.
Sub RemoveAlwaysOneSelectedMonth
set obj = ActiveDocument.GetSheetObject("LB01")
set boxfield=obj.GetField
set fprop = boxfield.GetProperties
fprop.OneAndOnlyOne = False
boxfield.SetProperties fprop
ActiveDocument.ClearAll True
End Sub