View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Changing cell values in a range to Hyperlink to sheet in workbook

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