Hide Tabs Based on the choice of Multiple Items from Drop Down List

**knopp** · 10-21-2021, 01:11 PM

Hello, I have a question regarding how to hide multiple sheets based on a user's selection from a drop down list. My spreadsheet has around 60 tabs (the sample only shows 30) and only 15-30 of these will be in use for a project. I would like the user to be able to use the drop down list to select which tabs they would like for the project and hide the rest.

My sample worksheet contains an tab labeled "Index" that uses a VBA code to pull the tab names from each sheet. The User Input sheet contains my attempt at solving this problem in VBA, however the code does not allow for multiple selections and is not hiding the correct sheets.

Does anyone know the solution to this issue? I have tried a lot of things but have not been successful. Any help would be much appreciated!

**6StringJazzer** · 10-21-2021, 03:12 PM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Hide Tabs Based on the choice of Multiple Items from Drop Down List

LinkBack

Thread Tools

Rate This Thread

Display

Hide Tabs Based on the choice of Multiple Items from Drop Down List

Re: Hide Tabs Based on the choice of Multiple Items from Drop Down List

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Hide Used Items in Drop Down List across multiple sheets

Multiple Time Stamps depending on choice in Drop Down List Choice

Hide used items from drop down list. (base ball teams selection for multiple innings)

Drop down list: unique value's, values based on that choice, search values based on choice

Hide Used Items in Drop Down List

Hide used items in drop down list & select multiple items in a drop down list

Hide-Unhide rows on multiple worksheets based on value of a drop down list

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions