VBA- return to original cell after followed hyperlink?

jmthompson

Well-known Member
Joined
Mar 31, 2008
Messages
966
Hey guys,
I am putting together a training guide in Excel. In this guide I have a sheet called "Key Terms". I have populated one of the other sheets with hyperlinks that take the user to the relevant definition on the Key Terms sheet.

What I am looking to do is add a button that will return the user back to the cell they followed the hyperlink from.

Any ideas?
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

jmthompson

Well-known Member
Joined
Mar 31, 2008
Messages
966
Nevermind. I realized that my original cell/range is still selected, all I have to do is select the original sheet. Since all of the hyperlinks are selected from the same sheet, easy peasy.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,314
Members
409,863
Latest member
stacy09
Top