Forum Discussion
hyperlinks to sheets within workbook
You can view the definition of the defined names by clicking on Name Manager in the Defined Names group of the Formulas tab of the ribbon.
If you delete a defined name, a hyperlink referring to it won't work anymore.
If you don't want users to change the name of worksheets, click Protect Workbook in the Protect group of the Review tab of the ribbon. You can specify a password if you like (don't forget it!)
Thank you for your response. Do you think it's preferable to use the Cell Reference type hyperlink as opposed to Defined Names? Also, does there need to be a value in the Type the cell reference field?
Named ranges can be a handy way to clarify what a cell means. If you use named ranges, it makes sense to use them in hyperlinks too. Apart from that, there is no special reason to prefer one above the other.
If you create a hyperlink to another sheet and leave the Cell Reference box empty, Excel will automatically enter A1 as cell reference.