Need An Answer To This!

T

Turquoise_dax

Is there a way to allows the user to follow a link contained in
protected cell?

There should be: a hand appears to show a link can be followed, but
click does no good....

I really need this....
(I am the file administrator, so I can change all settings... but th
cell needs to be locked.)

Thanx a zillion times to whoever answers this...:
 
R

robert111

if cell a1 is the sum of b1 + c1, you could attach a note to cell a
that says "sum of b1 and c1". This can be read on a protected sheet
 
S

Solutions4enterprise.biz

try using "Control" and "[" - this highlights the cells feeding the
destination cell or opens up linked files.
 
T

Turquoise_dax

I am talking about following a web hyperlink.

The cell cannot be selected, but the hand showing there is a link t
follow is still appearing when you get over it with the mouse. Is ther
a setting that can allow the link to be followed with a click even in
protected cell
 
T

Turquoise_dax

This is not working...

Just see for yourself: put a link in a cell, then protect the sheet fo
selection. The hand is still there, showing a default tip as "(...
click once to follow", but it cannot be followed... Is it that yo
simply CAN'T do it, no matter the setting, if the cell is protected:(
 
K

Kevin B

I was able to follow a link in a locked sheet by doing a Ctrl + Shift + Click
on the link.
 
T

Turquoise_dax

I tried it, but its not working. Any idea why?

(If I unprotect the sheet, the link works fine...):
 
T

Turquoise_dax

Two different answers came up, but they are not working for me. This has
to be a setting issue, but just can't find which one! :mad:
 
D

Don Guillett

In xl2002 when I protect the sheet there are options. If I do NOT check the
top one then I get the message that the cell is protected. If I do check the
option to allow users to access protected cells then I goto the hyperlink.
You did not mention version or how you have it set up on the sheet
protection.

BTW. In the future, please use meaningful subject lines for the benefit of
all in the archives.

--
Don Guillett
SalesAid Software
[email protected]
"Turquoise_dax" <[email protected]>
wrote in message
news:[email protected]...
 
T

Turquoise_dax

I edited the title, but the change only appear in the threaded mode, no
in the main menu...

But yeah, I see what u mean, I'll be careful next time.

T
 
Top