How do I hide tabs in excel based on a value in another tab?

[don456]

I have a "master" tab that has a dropdown menu (via a validation list) which will determine what the spreadsheet does. Based on the value selected via this dropdown, I would like to show the relevant tabs and hide the irrelevant tabs. I would prefer for this to happen automatically without a macro. Any ideas? I'm a total noob to VBA, so please talk real slow.

Thanks in advance

 

[Von Pookie]

Sorry, it would have to be a macro.

What are the dropdown entries and relevant sheets to hide/unhide?

 

[don456]

i have 3 dropdown items (call it ABC, XYZ, and 123). All three of these items would correspond to 3 different sub sheets I'd like to be shown (call it 1, 2, & 3), so nine sheets in all plus the master. So if ABC is selected in the master sheet dropdown, I'd like ABC1, ABC2, and ABC3 to be visible, but the other 6 sub sheets to be hidden.

Thanks so much for your help!

 

[don456]

FYI this help request was cross posted to Excel Forums as well--still learning the etiquette here and apologize for the cross post. Have not been able to figure this out yet, and would really appreciate any help. Thanks very much.

http://www.excelforum.com/excel-pro...in-excel-based-on-a-value-in-another-tab.html

 

[don456]

Anybody have any thoughts on this? Would really appreciate your help...I am in a bit of bind.

Thanks,
Don456

 

[don456]

Solved...thanks all.