Can I auto hide/unhide worksheets based on selected cell criteria.

**cwashburn** · 06-17-2013, 03:45 PM

I have a workbook with far too many tabs....I would like to be able to only see the tabs I need at the time based on selection criteria that I have established as follows:

I have 15 districts and anywhere from 1 to 50 locations within each district. Each location has its own tab. I have established a column that will fill-in the locations based on the district selected. I now only want to see the tabs that are associated to those locations. Any thoughts?

**Mordred** · 06-17-2013, 03:50 PM

Yes, we could devise some code that could unhide the sheet depending on what's in a particular cell. However, to do so without a sample workbook would be a lot of guessing and pointless coding for those that will be helping. So, if you could do as follows:

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**cwashburn** · 06-17-2013, 04:06 PM

OK, here is my sample workbook.

I have the "locations by District" tab unhidden and the tabs for the locations hidden. How do I automatically unhide the locations based on the criteria selected in column B of the "locations by district" tab.