View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Romileyrunner1 Romileyrunner1 is offline
external usenet poster
 
Posts: 73
Default Hyperlink to a specific worksheet in another workbook.

Hi,
I have a workbook which has columns numbered 1-80.
I want to place a hyperlink in each of these numbered cells that will take
me to a specified page e.g. #1 going to sheet 1, in another workbook.

I can insert a hyperlink that will take me to that workbook, no problems,
but there doesn`t seem to be an option to specify the worksheet: so it just
sends me to the last worksheet viewed.

Any ideas folks?
Thanks
RR1