Thread: Cell value & hyperlink
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
livin livin is offline
external usenet poster
  
Posts: 3
Default Cell value & hyperlink
I have a workbook with 250 sheets... named like so Sheet01...Sheet250

I want a cell to contain the number value of each sheet (01, 02, etc) while
also being a hyperlink so when the cell is clicked the workbook
automatically displays that sheet.

Any ideas?


Reply With QuoteReply With Quote