K
King
How can I remove a link?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron de Bruin
Hi King
Manual : Right click on the link and choose remove Hyperlink
To make text from all your hyperlinks use a macro like this
Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub
Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel
If you do Alt-F8 you get a list of your macro's
Select "test" and press Run
Manual : Right click on the link and choose remove Hyperlink
To make text from all your hyperlinks use a macro like this
Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub
Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel
If you do Alt-F8 you get a list of your macro's
Select "test" and press Run
J
John Wilson
King,
One way would be to search for the "[" (open square brackets) character
because it is used in linked formulas.
Another, even easier way....
Download this Add-In
http://www.bmsltd.co.uk/mvp/
John
One way would be to search for the "[" (open square brackets) character
because it is used in linked formulas.
Another, even easier way....
Download this Add-In
http://www.bmsltd.co.uk/mvp/
John
J
John Wilson
Ron,
Judging by the difference in our replies, I would guess that
the OP's question was a little vague?? <g>
John
Judging by the difference in our replies, I would guess that
the OP's question was a little vague?? <g>
John
R
Ron de Bruin
Hi John
He can choose now John<g>
I think you are right
He can choose now John<g>
I think you are right