Gooooood morning all,
Cell E3 contains a drop down list with several category in it (for reference worksheet a,b,c,d,e....)
I'd like to be able to hide/show worksheets when a category is selected e.g.
If Worksheet A is selected from the list B,C,D & E are hidden.
If Worksheet B is selected from the list A,C,D & E are hidden.
Would anyone able to produce a bit of VB that can fix this issue, I've tried to do it but with little success,
Thanks in advance,
Andrew
Bookmarks