Hyperlinks use the program's ribbon controls, while macros use Visual Basic code. With both methods, users click a button. ... Open the macro that you want to link to a worksheet.

A worksheet that is hidden by Visual Basic for Applications (VBA) code--which sets its Visible property to "xlSheetVeryHidden"--cannot be unhidden directly from the Excel user interface but may be ...