Total novice to this VBA guys so bear with me.
I want to hide / unhide sheets based on the value the user selects from a drop down menu. There are 3 choices possible in the drop down 1,2,3. The drop down menu is is cell D4
When "1" is selected I want to unhide sheet "Cat 1 7.5 Months" and keep "Cat 2 10 Months" and "Cat 3 12 Months" hidden
When "2" is selected I want to unhide sheet "Cat 2 10 Months" and keep "Cat 1 7.5 Months" & "Cat 3 12 Months" hidden
When "3" is selected I want to unhide sheet "Cat 3 12 Months" and keep "Cat 1 7.5 Months" & Cat 2 10 Months" hidden
Read lots of post and tried to implement and modify code to suit my needs. All failed so far....
HELP!! Please
Bookmarks