VBA Trouble - Help with code to hide and unhide worksheets
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.
| Attachment | Size |
|---|---|
| test.xlsm | 131.81 KB |

Recent comments
7 years 33 weeks ago
8 years 19 weeks ago
8 years 31 weeks ago
8 years 34 weeks ago
8 years 35 weeks ago
8 years 40 weeks ago
8 years 48 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago