I have some code that hides and unhides a worksheet in excel. I have attached my spreadsheet for reference.

So far if I click yes for 'Investigations" the worksheet 'site details' appears and if I click no it disappears.

My problem is that if I click no for another category e.g. 'dispersive soils' then I don't want the 'site details' sheet to disappear as it is ticked as a yes in another category.

Is there code that can help me?
I am fairly new to VBA so any help will be greatly appreciated.