Hi there - I would like code that creates or simulates a hyperlink between a cell one one worksheet and a cell on another wksheet in the same wkbook. The hyperlink needs to go both ways. The hyperlinked cells should be underlined or color formatted, making users aware of the link.
The link should be instantiated by a command in the right-click menu (right-clicking the first cell to be linked), or a triple-click of the first cell (this may be quicker than a right-click, menu item). The code then would "wait" until the second cell to be linked back to the first cell is selected somehow--such as with a double-click. The code should allow users to click sheet tabs, arrow keys, etc. in order to navigate to the second cell to be linked. A double-click or right-click on the second cell should end the linking process and code.
Clicking a linked cell on either sheet will take the user to the linked cell in the other sheet.
I've read about storing the first cell's (active cell's) reference as a variable, but don't know how to capture the ref of the second cell to be linked.
Thanks!
Here are some threads I was exploring:
http://www.ozgrid.com/VBA/right-click.htm
http://www.ozgrid.com/forum/showthread.php?t=39696
http://stackoverflow.com/quest…oto-functions-ctrl-and-f5