Using conditions to show/hide worksheets

You know, I looked at your sheet and noticed you have THREE cells with Majors in them and I can just guess your next question will be how to keep all of them and have their own sheets appear/disappear as choices are made. That's an entirely different approach than the one we've used so far.

Here's an updated sheet with the new approach. I left the Data Drop Menu Input sheet visible so you can see the changes.

Instead of Worksheet_Change on Student Information, we're going to use Worksheet_Calculate on the Data Drop Menu Input. Every time this sheet changes the other sheets will hide and unhide. Now why would this sheet change? Look at the stuff I've added.

First, I've added a second section of Majors that "shrinks" as choices are made on the main sheet. This second list is what is actually being used in your Data Validation on the main sheet. So when you select "Accounting", the option disappears from the drop down for the next choice. Pretty cool.

This is being done with the "Key" column I added. As choices are made, they lose their key in the index. This causes the second list to reorder and since this happens in formulas, the RAND() formula in cell G1 creates an actual "change" in the sheet and THAT triggers the new macro to hide and unhide sheets.

In effect the new macro unhides sheets that have lost their index value in the "Key" section. If there is a number there, the sheets stay hidden.

Anyway, it works. You can now make choices on the main sheet all you want and the sheets will hide/unhide.