Unhide tab based on drop-down list selection

Hello-

I have a sheet, "MOC", that contains 7 yes/no questions.

If "Yes" is selected for Question 1, the rest of the questions on the "MOC" tab will be hidden, and the "SRMForm" tab will be unhidden.

Can someone help me with this code, specifically the unhiding of the other tab?

Thanks,
CMR

I was doing this the other day, here was my code for my workbook. This would go on your first page and you can adjust it how you would like. If you upload your workbook, we can curtail my code to fit yours. Visible means the sheet is visible, Hidden means that you cannot see it but a user could easily unhide the sheet, and veryhidden means that the user has to unhide the sheet via VBA

Please Login or Register  to view this content.

Hello-

I've attached my file.

Thanks for your help!

CMRDraft Form.xls

CMR

Here is your workbook, All that i have done is deleted all of your code on all of your other pages, added my code to your MOC page and put some conditional formatting and statements in the cells on MOC to make them only show up if you input NO in the first question. Check it out and let me know if this works for you.

amotto11-

That worked great. I'm going to work with it to finish out the sheet. I'll let you know if I have any questions.

Thanks and have a great day!
CMR