View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Chatnoir Chatnoir is offline
external usenet poster
 
Posts: 3
Default having trouble locking hyperlinks in excel

Gary's 2nd method worked for me. Thanks! I'll try Dave's too - it looks a
little easier.Appreciate the great help.
--
Thanks! Chatnoir


"Dave Peterson" wrote:

If you used insert|Hyperlink, then you should try using the named range again.
It should work ok.



Chatnoir wrote:

Hi all. I have a workbook with multiple worksheets. I have hyperlinks between
the first worksheet and others in the book, just using the cell reference (eg
E4). The problem I have is when I add a row, the links are messed up.

I tried naming the cells I'm linking to, but then the links didn't work at
all.
Any ideas?
--
Thanks! Chatnoir


--

Dave Peterson