Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
snidely
 
Posts: n/a
Default Link - deactivate being sent to source when click on linked cell?

I have figured out how to set up a link from a cell in one book to a cell
in another book. At first all i could do was the"hyperlink" thing with
underlines etc. Now i link and the display is in plain text format.
Problem is, tho, if i click on a cell that is linked to another book, it
takes me to that other book. (There are times i click on a linked cell to
change formatting etc.) Is there anyway to deativate the "feature" of
automatically being taken to the "source" workbook?

Thanks.

....mike
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

It sounds like your hyperlink is still there, but the cell isn't formatted in a
hyperlink style.

Select the cell and hit Insert|Hyperlink (or ctrl-k)

See if your link is still there.

====

If you have a link that appears normal, but you want it to look like a link
(blue, underlined), then select the cell
format|style|and choose hyperlink from the dropdown menu

(You may have to add a hyperlink to a helper cell for Hyperlink to show up in
that dropdown. After you have one, you can clean up that helper cell
(Edit|clear).)

snidely wrote:

I have figured out how to set up a link from a cell in one book to a cell
in another book. At first all i could do was the"hyperlink" thing with
underlines etc. Now i link and the display is in plain text format.
Problem is, tho, if i click on a cell that is linked to another book, it
takes me to that other book. (There are times i click on a linked cell to
change formatting etc.) Is there anyway to deativate the "feature" of
automatically being taken to the "source" workbook?

Thanks.

...mike


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change cell back color on click Dave Peterson Excel Discussion (Misc queries) 0 January 24th 05 10:50 PM
How do I link many cells to one particular cell? fish@divi Excel Discussion (Misc queries) 2 January 4th 05 11:00 PM
Undoing LINKS in Excel 2000 jayceejay New Users to Excel 3 January 4th 05 05:58 PM
How do I link many cells to one particular cell? justinfishman22 Excel Discussion (Misc queries) 2 January 4th 05 12:09 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 09:25 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"