View Single Post
  #1   Report Post  
livin
 
Posts: n/a
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?