View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike[_51_] Mike[_51_] is offline
external usenet poster
 
Posts: 13
Default hyperlink to another workbook and a specific sheet

Try naming the sheet and range in the Hyperlink's SubAddress.

Mike F
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