Thread
:
hyperlink to another workbook and a specific sheet
View Single Post
#
5
Posted to microsoft.public.excel.programming
Daniel[_21_]
external usenet poster
Posts: 7
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
Reply With Quote
Daniel[_21_]
View Public Profile
Find all posts by Daniel[_21_]