View Single Post
  #1   Report Post  
Old August 6th 07, 12:30 PM posted to microsoft.public.excel.programming
Banzai Banzai is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2007
Posts: 3
Default hyperlink to sheet name where sheet names=cell content

Can anybody tell me how to achieve the above. For instance, on sheet1 if
cell A1 contents are 'case 4576' i want to be able to click on cell A1/sheet
1 which will take me directly to a sheet named 'case 4576' - or to any sheet
name whereby the sheet name equals the content of cell A1.