Hyperlinks - relative references

[swaatacba]

I have in previous versions of Excel (Excel '97) created hyperlinks
that were relative to the current/active worksheet.

For example if you create a worksheet called 'Intro' with a hyperlink
at cell H3 pointing to cell A300 and then copy the worksheet to a new
workbook and rename the sheet; then hyperlink in the new sheet cell H3
points to A300 in the new sheet.

I seem unable to employ the same tactic under Excel 2003. Any thoughts/
advice.

 

[Jim Rech]

I haven't used hyperlinks much but I see that in Excel 97 you could create a
hyperlink like "C10" while in Excel 2003 the active sheet's name
automatically added (e.g., Sheet1!A10) whether you want it or not.

And since hyperlinks are just text entries they do not automatically get
updated, like formulas do, when the sheet name is changed, so they are
broken by doing so.

I find though that you can create a 'hyperlink without sheet name' in Excel
2003 with a macro like this:

ActiveCell.Hyperlinks(1).SubAddress="c10"

If no one has a better suggestion this may be your only workaround.


--
Jim
|I have in previous versions of Excel (Excel '97) created hyperlinks
| that were relative to the current/active worksheet.
|
| For example if you create a worksheet called 'Intro' with a hyperlink
| at cell H3 pointing to cell A300 and then copy the worksheet to a new
| workbook and rename the sheet; then hyperlink in the new sheet cell H3
| points to A300 in the new sheet.
|
| I seem unable to employ the same tactic under Excel 2003. Any thoughts/
| advice.
|

 

[swaatacba]

Jim

Yep, that's the one. I've used the same macro in a user form to give
me easier accessibility.

Stephen Allen