Hi there,

I have a workbook where I require the following to occur. The purpose of the exercise is to present one set of sheets for completion depending on on of two conditions being met - I know that with VB this should be reasonably straightforward but unfortunately I have no VB skills at all, so please be very explicit as to how to achieve this and how to get it into the workbook.

If sheet1 cell E37 has 'Yes' selected, I want sheets 3-9 to be hidden (all other sheets visible)
If sheet1 cell E37 has 'no' selected, I want sheets 10-16 to be hidden (all other visible)
If sheet1 cell E37 is cleared or has no selection made, I want all sheets visible.

Grateful for any help or advice you can give.

Ed