DID YOU KNOW?…
that you can create a hyperlink from an object to a VBA procedure. In
Excel 97, make a text box on a worksheet and right-click its edge. Then,
select Insert, Hyperlink from the menu and type the name of the procedure
in the Named Location in File box.
NOTE: The manual setting of a procedure name as a hyperlink subaddress
apparently cannot be done in Excel 2000. Not only does the dialog box not
allow that option, it does not allow the use of names that do not yet exist,
unlike Excel 97. In my opinion, there was no reason to add an extra
validation step to see if the name exists, since the option to add the name
at a later time increases the flexibility of this feature. However, you can
still set/change the SubAddress of the hyperlink programatically in Excel
2000 for VBA procedures.