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
|