| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need An Answer To This!
Is there a way to allows the user to follow a link contained in a protected cell? There should be: a hand appears to show a link can be followed, but a click does no good.... I really need this.... (I am the file administrator, so I can change all settings... but the cell needs to be locked.) Thanx a zillion times to whoever answers this...:) -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
if cell a1 is the sum of b1 + c1, you could attach a note to cell a1 that says "sum of b1 and c1". This can be read on a protected sheet. -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
try using "Control" and "[" - this highlights the cells feeding the
destination cell or opens up linked files. "Turquoise_dax" wrote: Is there a way to allows the user to follow a link contained in a protected cell? There should be: a hand appears to show a link can be followed, but a click does no good.... I really need this.... (I am the file administrator, so I can change all settings... but the cell needs to be locked.) Thanx a zillion times to whoever answers this...:) -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
I am talking about following a web hyperlink. The cell cannot be selected, but the hand showing there is a link to follow is still appearing when you get over it with the mouse. Is there a setting that can allow the link to be followed with a click even in a protected cell? -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
This is not working... Just see for yourself: put a link in a cell, then protect the sheet for selection. The hand is still there, showing a default tip as "(...) click once to follow", but it cannot be followed... Is it that you simply CAN'T do it, no matter the setting, if the cell is protected:( ? -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
I was able to follow a link in a locked sheet by doing a Ctrl + Shift + Click
on the link. -- Kevin Backmann "Turquoise_dax" wrote: Is there a way to allows the user to follow a link contained in a protected cell? There should be: a hand appears to show a link can be followed, but a click does no good.... I really need this.... (I am the file administrator, so I can change all settings... but the cell needs to be locked.) Thanx a zillion times to whoever answers this...:) -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
I tried it, but its not working. Any idea why? (If I unprotect the sheet, the link works fine...):( -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
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!  -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
No need to wait to use a better title...:) Thanx a lot -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
glad to help. But, please use a better title in the future. Some don't
bother to read meaningless subject lines. -- Don Guillett SalesAid Software "Turquoise_dax" wrote in message news:Turquoise_dax.29cncp_1150216807.2811@excelfor um-nospam.com... No need to wait to use a better title...:) Thanx a lot -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need An Answer To This!
I edited the title, but the change only appear in the threaded mode, not in the main menu... But yeah, I see what u mean, I'll be careful next time. Tx -- Turquoise_dax ------------------------------------------------------------------------ Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185 View this thread: http://www.excelforum.com/showthread...hreadid=551402 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP not returning correct answer | Excel Worksheet Functions | |||
| variable Addition and substraction | Excel Worksheet Functions | |||
| how do i use 'if' command to display answer in different cell? | Excel Discussion (Misc queries) | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
| coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Linear Mode
