Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is hyperlink function inactive sometimes?
I've noticed that in some excel files the hyperlink function is active, but
in other files it is not active. I haven't been able to figure out why some files work and some don't. Is there some sort of worksheet protection feature that allows some editing but does not allow hyperlinks? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is hyperlink function inactive sometimes?
You are correct! Say you click on a cell and type
http://www.cnn.com and you want the link to be "clickable. BEFORE typing the hyperlink: Tools Options Spelling AutoCorrect AutoFormat as you type and check the Internet & Newwork paths checkbox. -- Gary''s Student - gsnu200801 "Race Spanner" wrote: I've noticed that in some excel files the hyperlink function is active, but in other files it is not active. I haven't been able to figure out why some files work and some don't. Is there some sort of worksheet protection feature that allows some editing but does not allow hyperlinks? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is hyperlink function inactive sometimes?
Thanks - I followed the path you described and the internet feature was
already checked. I usually follow the InsertHyperlink feature but this dioesn't work all of the time. "Gary''s Student" wrote: You are correct! Say you click on a cell and type http://www.cnn.com and you want the link to be "clickable. BEFORE typing the hyperlink: Tools Options Spelling AutoCorrect AutoFormat as you type and check the Internet & Newwork paths checkbox. -- Gary''s Student - gsnu200801 "Race Spanner" wrote: I've noticed that in some excel files the hyperlink function is active, but in other files it is not active. I haven't been able to figure out why some files work and some don't. Is there some sort of worksheet protection feature that allows some editing but does not allow hyperlinks? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is hyperlink function inactive sometimes?
A guy I work with found what my issue was. The hyperlink function is not
active when the "Share Workbook" function is enabled. Disabling this feature allows hyperlinks to be inserted. Thanks "Race Spanner" wrote: Thanks - I followed the path you described and the internet feature was already checked. I usually follow the InsertHyperlink feature but this dioesn't work all of the time. "Gary''s Student" wrote: You are correct! Say you click on a cell and type http://www.cnn.com and you want the link to be "clickable. BEFORE typing the hyperlink: Tools Options Spelling AutoCorrect AutoFormat as you type and check the Internet & Newwork paths checkbox. -- Gary''s Student - gsnu200801 "Race Spanner" wrote: I've noticed that in some excel files the hyperlink function is active, but in other files it is not active. I haven't been able to figure out why some files work and some don't. Is there some sort of worksheet protection feature that allows some editing but does not allow hyperlinks? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink tool inactive | Excel Discussion (Misc queries) | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Find Inactive | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |