4 Replies Latest reply: Aug 19, 2015 5:55 AM by Sundarakumar Kalaimani RSS

    listbox with filtered values

    Christian Wylezol

      Good Morning,

       

      I have some difficulties with the entries of a listbox. I create a quicklink-listbox for the users to open Diagrams and Tablebox via Trigger.

       

      Here is the Challenge:

      I need to have in the Listbox the entries of all Objects with ObjectType = Pivot-Table or TableBox from the Sheets, that are not hidden.

      The Main Problem for me are the "already filtered" entries in the listbox. (It is not about "Hide Excluded" within the properties of the listbox.)

      What exactly is the Expression for "if sheet is not hidden"?

       

      At the Moment I see all Objects. he Listbox Expression is: =ObjectID&' '&ObjectName

       

      Does somebody of you have an idea? Would be great.

       

      Thanks alot in advance

      Chris