Choose random tabs via dropdown

Hi All,

I am trying to create a Macro which allows me to choose random Tabs from a Dropdown.

Explanation:

I have large number of sheets - Lets say from 1 till 15. What I want on sheet number 1 is to have a dropdown which allows me to choose multiple tabs of my choice. Till now I managed to have a Macro which either shows me All sheets or shows me the selected one. Below is the code:

Please Login or Register  to view this content.

What I need is the possibility to choose random multiple tabs at same time for e.g 2,5,6,9 from a dropdown. There is no specific combination.

Thanks for the help in advance.

Greetings,
Kim

updated with code tags

Hi all,

I am not sure but I think I only need additional line of code which dont hide the selected tabs and keep the selection unhidden.
Any suggestions.

Thanks in advance for help"

Maybe you can adapt these macros:
initializes a listbox on sheet11 with the names of the sheets in a workbook when it is opened.

Please Login or Register  to view this content.

this one hides the sheets, except sheet11 when the book is closed.

Please Login or Register  to view this content.

this one is attached to a button on sheet11 that unhides the sheets selected in the listox.

Please Login or Register  to view this content.