software

I am trying to set up a hyperlink on one worksheet in a workbook that will
point to and highlight a group of cells in another worksheet in that same
workbook. I am using Excel 2003.


quot;barronkaquot; gt; wrote in message
...
gt;I am trying to set up a hyperlink on one worksheet in a workbook that will
gt; point to and highlight a group of cells in another worksheet in that same
gt; workbook. I am using Excel 2003.

To name cells, highlight them, and do either of two things:

Click Insert, Name, Define, and enter a name.

or:

Click the mouse in the name box at the top left, where you normally see the
address of the current cell. Type a name there for either a single cell, or
whatever range you have selected.

1 Define the group of cells by: Insertgt;Namegt;Definegt;
2 Create a name for the group of cells, in the refers to box, indicate
location of your group of cells.
3 Select cell where you want to put the hyperlink
4 Insertgt;Hyperlink
5 Select Place in this document
6 Select the named range under Defined Names
Hope this helps
barronka Wrote:
gt; I am trying to set up a hyperlink on one worksheet in a workbook that
gt; will
gt; point to and highlight a group of cells in another worksheet in that
gt; same
gt; workbook. I am using Excel 2003.--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: www.excelforum.com/member.php...oamp;userid=31909
View this thread: www.excelforum.com/showthread...hreadid=520600