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.

If opening the Developer tab and clicking a button is a little too much work, you can also open the editor with the keyboard shortcut Alt+F11, which works whether the Developer tab is enabled or not.