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
Bookmarks