How to generate a list of hyperlinks in Excel It’s not unusual for a complex workbook to include a list of hyperlinks to each sheet in the workbook.

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

VBA often has a lower barrier to entry for those already familiar with the Excel environment. It’s integrated into Excel. You can record a macro and start tweaking the generated code quickly.