Remove Hyperlinks

  • Thread starter Thread starter Elaine
  • Start date Start date
E

Elaine

Hello,

I'm using Excel 2007 and want to remove hyperlinks from a multiple cells. I
got the following code from the "General" user group and it doesn't work for
me. Can you tell me what I'm doing wrong?

I pressed Alt + F11, then Ctrl + G, and pasted the following code:

Sub
'
' Macro2 Macro
'

'
Cells.Select
Sub DelAllHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub
 
Press Alt-F11
Press Ctrl-G

Paste just this one line.

ActiveSheet.Hyperlinks.Delete

After you paste it, the cusor will move to the next blank line. Move
the cursor back up to the end of the line you pasted so that it's
flashing after "Delete". Then press enter. This should run the code
on the worksheet that you have active.
 
All I can say is that both of you are GREAT!

Thank you for your quick response to my question.
 
Back
Top