View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
kgraybill kgraybill is offline
external usenet poster
 
Posts: 1
Default Preserving hyperlinks when rows are added

This is just what I was looking for but is it possible to have the link open
at the top veiwing row instead of somewhere in the middle of the screen?

"Dave Peterson" wrote:

And if you're using the Insert|Hyperlink version of hyperlinks, you could give
the target a name (insert|Name|define).



Jimbob wrote:

In an Excel 2003 workbook, I have several hyperlinks to hlp navigate around.
The difficulty is when additional rows or columns are added they displace the
target cell reference. In this situation, is it possible to ensure a
hyperlink from a cell takes me to the intended data in a target cell after it
is displaced?
I'd like to achieve this without the use of macros (if possible).
Thanks


--

Dave Peterson