Excel-Hyperlinking

  User-312386 20:07 05 Nov 2006
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 2006

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 2006

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

  User-312386 20:21 05 Nov 2006

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

  User-312386 20:24 05 Nov 2006

same with ultimate add-in

No tool bar at the top

  User-312386 20:32 05 Nov 2006

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 2006

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 2006

Prevent hyperlinks being created click here

  User-312386 20:46 05 Nov 2006

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.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?