table of content page in excel
 

i was able to set up the hyperlink but i would also like to include the page
number in the table of content page. how do i get it to look like this.

Report..............1
Report II...........2

table of content page in excel
 

Are you creating the hyperlink using InsertHyperlinkPlace in this Document?

If so, you can supply the text in the "Test to Display" dialog box when you edit
the hyperlink.


Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 16:10:02 -0700, FMMM wrote:

i was able to set up the hyperlink but i would also like to include the page
number in the table of content page. how do i get it to look like this.

Report..............1
Report II...........2

table of content page in excel
 

I'm creating my hyperlink through insert - hyperlink-place in this document
but I dont see the test to display dialog. Can you please give me step by
step on how i can use this to add the page number.

Thanks so much

"Gord Dibben" wrote:

Are you creating the hyperlink using InsertHyperlinkPlace in this Document?

If so, you can supply the text in the "Test to Display" dialog box when you edit
the hyperlink.


Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 16:10:02 -0700, FMMM wrote:

i was able to set up the hyperlink but i would also like to include the page
number in the table of content page. how do i get it to look like this.

Report..............1
Report II...........2

table of content page in excel
 

Was a typo......should have read ''Text to display" not "Test to display"

InsertHyperlink and a dialog will open.

On left side is a menu of places to link to.

At top is a dialog box named "Text to Display"

Type Report.........Page 1 into that dialog box.


Gord

On Thu, 23 Aug 2007 10:46:02 -0700, FMMM wrote:

I'm creating my hyperlink through insert - hyperlink-place in this document
but I dont see the test to display dialog. Can you please give me step by
step on how i can use this to add the page number.

Thanks so much

"Gord Dibben" wrote:

Are you creating the hyperlink using InsertHyperlinkPlace in this Document?

If so, you can supply the text in the "Test to Display" dialog box when you edit
the hyperlink.


Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 16:10:02 -0700, FMMM wrote:

i was able to set up the hyperlink but i would also like to include the page
number in the table of content page. how do i get it to look like this.

Report..............1
Report II...........2