listbox with filtered values

[#1]

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

[ashwanin]

Hi Chris,

Can you please post some sample data?

[#3]

Good Morning,

please find attached a sample.

The listbox with the blue Header is my quicklink-list.

Here I Need to see just the pivottables and tableboxes from not hidden Sheets.

At the Moment I dont know where to find the info, that a sheet is hidden.

Thank you.

Chris

[sundarakumar]

Hi Christian,

Is this being created from project files?

-Sundar

[#5]

Hi sundar,

this file is directly from the source. Please find attached the source file. I want the listbox to work in the source.

Thanks.

Chris