Thread: hyperlink to sheet name where sheet names=cell content
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Banzai Banzai is offline
external usenet poster
  
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.

Thks


Reply With QuoteReply With Quote