Excel 2007 - can I hyperlink to a text box on another worksheet?

TamzC2 · 05-23-2009, 02:06 PM

Hi there,

This may well be a daft question, but is it possible have a hyperlink in a cell on one worksheet that links to a text box on another worksheet in the same workbook?

I have tried using 'Define Name' to name the text box, but although it then appears in the 'Name Manager' on the worksheet, it doesn't appear in the 'Defined Name list' in the 'Place in this document' option for the Hyperlink on the other worksheet.

Any help would be greatly appreciated,

Tamz

swampydrill · 05-23-2009, 02:52 PM

I don't think you can hyperlink to a text box but you can hyperlink to another cell which is on a different worksheet, just choose place in this document and choose the sheet number

05-23-2009, 02:06 PM	#1 (permalink)
TamzC2 Registered User Join Date: May 2009 Posts: 1 OS: Windows Vista 32bit	Excel 2007 - can I hyperlink to a text box on another worksheet? Hi there, This may well be a daft question, but is it possible have a hyperlink in a cell on one worksheet that links to a text box on another worksheet in the same workbook? I have tried using 'Define Name' to name the text box, but although it then appears in the 'Name Manager' on the worksheet, it doesn't appear in the 'Defined Name list' in the 'Place in this document' option for the Hyperlink on the other worksheet. Any help would be greatly appreciated, Tamz

05-23-2009, 02:52 PM	#2 (permalink)
swampydrill Registered User Join Date: May 2007 Posts: 44 OS: xp	Re: Excel 2007 - can I hyperlink to a text box on another worksheet? I don't think you can hyperlink to a text box but you can hyperlink to another cell which is on a different worksheet, just choose place in this document and choose the sheet number