View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Cox[_2_] James Cox[_2_] is offline
external usenet poster
 
Posts: 39
Default Hyperlinking to an Autoshape?

Autoshapes have hyperlink attributes, so it's easy to hyperlink from a
autoshape to a cell, named range, file or url.

But, is there any way to hyperlink *TO* an autoshape? The best I've been
able to do is to use the TopLeftCell / BottomRightCell to get a range to
hyperlink to, but with row / column inserts or just moving the autoshape,
that range rapidly gets out-of-sync with the actual autoshape location.

Any thoughts will be most appreciated!

James