IF <checkbox> THEN HYPERLINK

[bmasella]

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?

[JBeaucaire]

Create your check box, then doubleclick on it and insert this code between the top and bottom rows:

Please Login or Register  to view this content.

The lines in grey are an example of the top and bottom rows of code.

[JBeaucaire]

BTW, it would be simple to add the ability of the checkbox to hide/unhide the associated sheets, as well.