View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Daniel[_21_] Daniel[_21_] is offline
external usenet poster
 
Posts: 7
Default hyperlink to another workbook and a specific sheet

Thanks for your response.
Can you, please, be a little more explicit?
my code :
Range("C11").Hyperlinks(1).follow points only to the workbook
Daniel
"Tom Ogilvy" a écrit dans le message de news:
...
Use the subaddress as well.

--
Regards,
Tom Ogilvy

"Daniel" wrote in message
...
Hello all.
Is it possible to use VBA to point to another workbook AND a specific

sheet
?
There is no problem when the link is used manually. When using VBA, the

link
is only pointing to the "address" part of the link, so you cannot reach

the
sheet and cell you wanted.
Thanks in advance.
Daniel