I have looked and looked and cannot find an answer to my problem so figured I would post to see if anyone has a quick fix.

I have a workbook with multiple tabs. I want to set up an event whereby if Cell A4 on my Inputs Tab is "Yes" (using a drop down list) then several hidden tabs (three to be exact) will appear. If the same cell is "No" then the tabs remain hidden.

I can find events that create and delete tabs, but am having a heck of a time finding one that "hides" or "unhides" existing tabs in the same workbook.

Any ideas? Thanks in advance.