Get.Workbook function
now browsing by tag
AcroForms
add controls to form
Arbitration
Autoexpand
BookMarks
defined tables
Dynamic Hyperlinks
enable macros
Excel
Excel 1013
excel 2007
excel 2010
excel 2013
Excel Defined Names
Excel Linear Interpolation
Excel ScoreBoard
excel to pdf
excel userform
excel vba form
expand userform
Export XML Data From Excel
fill combo
Header Row
hide excel sheets
Mail Merge
Map Excel to Word
Mass Metters
PDF Form
pdf to excel
Ping Pong
protect sheet
range to array
Table Components
tables
Table Tennis
TextBox
TextBox Change Event
TextBox Exit Event
Totals Row
UDF
VBA Interpolate
vba user form
workbook protection
XFA Forms
XML Data
Dynamic Hyperlinks in Excel
Dynamic Hyperlinks in Excel to navigate between Worksheets
Adding a hyperlink to a specific worksheet or cell is an easy thing to do. But what if you need the hyperlink to be dynamic, no matter if you insert or delete sheets, change the order of sheets?
Or, if you start from a template sheet, and keep adding sheets, you need to have dynamic hyperlinks in the template sheet, that “knows” which is the next or previous sheet, without manually adjusting all hyperlinks.
Few things you should know:
You have multiple options to create a hyperlink (without VBA):
- you can add a hyperlink to a cell, by right clicking that cell and selecting Hyperlink from right click menu;
- add a hyperlink to a shape, by right clicking that cell and selecting Hyperlink from right click menu; (very similar to adding a hyperlink to a cell)
- add a hyperlink in a cell using the Excel Hyperlink Function.