I have an open workbook named "Main".
I also have a closed workbook named "SubOne".
In "SubOne", cell A1 I have a Hyperlink.
Is there a way of activating this Hyperlink from workbook "Main" ?
The activating cell in workbook "Main" can be any cell that I have selected.

Example: If I clicked on cell D2, workbook "Main", the Hyperlink in cell A1, workbook "SubOne" would be activated.

The idea being that the user can change the Hyperlink in "SubOne", but can not change anything on "Main" as it is protected.