Good afternoon all,

I have a slight problem on excel which cannot be answered by the powers of the internet (who knew...).

I have a workbook with a overview sheet and then a number of sheets after (around 38). The sheets are colour coded within groups and work off each other in order to produce calculations.

I am trying to set up a checkbox on the overview sheet which will show / hide the relevant sheets within the work book (to prevent scrolling through all sheets to get to the relevant one). This may be a simple task of adding a checkbox or alternatively a basic macro (to note i have v. basic macro skills).

Any help would be greatly appreciated.

EB