Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Within our application, we have several fields which are used to control navigaton and other flow within the application. These fields have no meaning to the application user and so can be confusing if displayed, How do we exclude these fields from the current selection box?
Here is what displays now. The field marked with a yellow highlighter is what we wish to exclude.
Hi
Try like this
set HidePrefix = '%' ;
Then While load the field, rename as %FieldName;
Its hide the fieldname;
Tag ActiveSheet as $hidden
Have you tried using alternate states
Dear Vahanan Ramasamy,
if i use set hide prefix with section access . my section access is not working. if i remove set hideprefix my section access working fine.
Dear Ken Jones,
try this
Sheet Properties -> Triggers - > Add action - > ADD - > ACtionType - > Selection - > Clear Field - > select the needful fields
Hi Mayil,
When I added these to the script, it worked as specified. Thanks.
Ken
When I try to do this in the script, I get and error on the "as" .. Should I be trying to accomplish this elsewhere?
Sorry no "as"
TAG Field yourfield $hidden;
Unfortunately, clearing this field results in conditionally "hidden sheets" becoming visible ... and if we wanted that, we wouldn't need the "ActiveSheet" field. Thanks for the thought.