Hyperlinks use the program's ribbon controls, while macros use Visual Basic code. With both methods, users click a button or text label to switch to a different spreadsheet.