View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Elaine Elaine is offline
external usenet poster
 
Posts: 106
Default Remove Hyperlinks

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
--
Thank you... Elaine