View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daniel.C[_2_] Daniel.C[_2_] is offline
external usenet poster
 
Posts: 105
Default deleting lots of hyperlinks in Excel 2007

Execute the following macro :

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

HTH
Daniel

I have 280 hyperlinks in Excel 2007 worksheet which I want to delete without
having to do each one manually. Does anyone know a short cut that will
delete them all in a few key strokes? Many thanks in anticipation