I have a training needs analysis workbook with 12 sheets each with a different subject.
On the first sheet there are 11 checkboxes listing the subjects, which when ticked unhide the relevant sheets. this works well
On each sheet I have a 2 buttons "Forward" and "Back" linked to "ActiveSheet.Previous.Select" and "ActiveSheet.Next.Select" however if a sheet is hidden I get a run time error select method of worksheet class failed.
How do I bypass the hidden sheet or sheets (there may be a number together)
Thanks Graham