Hello,

I'm trying to write a case statement for 4 different cases based on 2 worksheets and if they are visible or not. Ex.

Case Neither x or y visible
Do 1

Case Both x and y visible
Do 2

Case Sheet x visible
Do 3

Case Sheet y visible
Do 4

There will always be other sheets visible so I need the cases to be specific. I've tried multiple combinations and can't get them to work as describe above. Biggest problem is when both or neither are visible.

Thanks for the help.