Excel-Hyperlinking

  User-312386 20:07 05 Nov 06
Locked

Hi all

I don't want Hyperlinking on in Excel

Can someone please tell me how to turn the damn thing off please.

I know i can right click and remove the hyperlink and also click edit and undo hyperlink.

I can't find anything in the options at all.

I have a 600 cell spreadsheet to do all with e-mail addresses

Thanks in advance

Madboy

  VoG II 20:12 05 Nov 06

Install ASAP Utilities click here

Select the range of cells containing hyperlinks. On the ASAP menu Web > Remove all hyperlinks in selected cells.

  VoG II 20:16 05 Nov 06

Ultimate Add-in click here has something similar in Range > Hyperlink tools.

  User-312386 20:21 05 Nov 06

I install the ASAP utility but no tool bar is present at the top to do this

  User-312386 20:24 05 Nov 06

same with ultimate add-in

No tool bar at the top

  User-312386 20:32 05 Nov 06

i am such an idiot

Might help if i enabled macros security

VoG™

You are a star mate

Worked a treat and all removed

Many thanks

  VoG II 20:32 05 Nov 06

Very odd!

Try this. In your workbook press ALT + F11 to open the Visual Basic Editor. Insert > Module. Copy the following code and paste it into the module.

Sub RemoveLinks()
Dim cel As Range
For Each cel In ActiveSheet.UsedRange
cel.Hyperlinks.Delete
Next cel
End Sub

Close the VBE. On your sheet with hyperlinks, Tools > Macro > Macros, click on RemoveLinks then click the Run button.

  VoG II 20:43 05 Nov 06

Prevent hyperlinks being created click here

  User-312386 20:46 05 Nov 06

Thats the one i want.

The microsoft one worked a treat

I knew it was there somewhere

Thanks again

And

Those utilities are good

Thanks once again mate

Madboy

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos