I would like to be able to build a hyperlink based on whether a check box has been checked or not...

The link would actually just take me to another worksheet in my workbook for a page that I call the index...

In short...

If the Checkbox is checked create a hyperlink called "Sheet1" that when clicked would take me to A1 in Sheet1. If the checkbox is NOT checked I would see the title Sheet1 but there would be no Hyperlink to it.

Ideas?