Is there any way to clear a single filed selection instead clearing all on moving one sheet to another sheet.
In general actions has clear all function but there is no single field clear.
I know it is possible through macro, but I don't want to use macro for this.
help would be much appreciated.
Use the Selection, Toggle Select action, and set the following search string:
=chr(40) & GetFieldSelections(Field, chr(124)) & chr(41)
Hope that helps.
Hi Chenna ,
I have a simple solution,
on Sheet Leaving Actions, add an action like,
select in field, Write your Field name in the FieldName box and Dont give anything in the Search String box.
it will work. here when we are leaving the sheet, we just select the field with null value, then immediatly it will get unselected. try it once....