I have on sheet1(Enter-Exit Page) a list that grows as new sheets are added,
that displays a cell value.
They are displayed in the range O4:O48, as this is the MAXIMUM number of
sheets that the Workbook will contain.
However i want to be able to have the values displayed on the Enter-Exit
Page as a hyperlink to the particular worksheet that value is from.
How can i do this, considering that there amy only be a few values, until
eventually O4:O48 will have values.


Regards

Corey

Possibly
Look at the hyperlink worksheet function in Excel help.

If that won't work, then you will depending on how data is entered and what
would trigger the creation of a hyperlink, you would look at the change
event.

http://www.cpearson.com/excel/events.htm
for an overview of Events (Chip Pearson's site)

--
Regards,
Tom Ogilvy


"Corey" wrote in message
...
I have on sheet1(Enter-Exit Page) a list that grows as new sheets are
added, that displays a cell value.
They are displayed in the range O4:O48, as this is the MAXIMUM number of
sheets that the Workbook will contain.
However i want to be able to have the values displayed on the Enter-Exit
Page as a hyperlink to the particular worksheet that value is from.
How can i do this, considering that there amy only be a few values, until
eventually O4:O48 will have values.


Regards

Corey

Just insert a normal hyperlink that points to any cell in any sheet, but add
an '=' before the text to display.


"Corey" schreef in bericht
...
I have on sheet1(Enter-Exit Page) a list that grows as new sheets are
added, that displays a cell value.
They are displayed in the range O4:O48, as this is the MAXIMUM number of
sheets that the Workbook will contain.
However i want to be able to have the values displayed on the Enter-Exit
Page as a hyperlink to the particular worksheet that value is from.
How can i do this, considering that there amy only be a few values, until
eventually O4:O48 will have values.


Regards

Corey