Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Hello,
Use the Selection, Toggle Select action, and set the following search string:
=chr(40) & GetFieldSelections(Field, chr(124)) & chr(41)
Hope that helps.
Hi,
In the action "Leaving Sheet" use the following macro code:
ActiveDocument.Fields("Class").Clear
Regards.
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....
Thanks Arjun, it works fine....
Sorry (name mistake).. Arun.
Hello Arun,
Nice one. Sometimes the easier is the better.
Thanks!
Many thanks Arun - I had exactly the same issue.
Wow it works like a magic ..
I tried the same for open sheet.
Thanks.