Deleting hyperlinks from a worksheet

**shamtime** · 04-26-2009, 03:11 PM

Is there any way to simultaneously delete all hyperlinks from a worksheet? I know how to delete hyperlinks cell by cell, but not how to delete them column by column, row by row, or best yet, delete all links on a worksheet or file. Thanks.

**martindwilson** · 04-26-2009, 03:17 PM

put this in a module and run

Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Sub

**hardeep.kanwar** · 04-27-2009, 02:00 AM

Couple of Options

1. Select the Sheet By Using CTRL+A,
Press ALT+11 Then CTRL+G, Now Type Selection.Hyperlinks.Delete than Ok

2. Copy Any Blank Cell
Select the Range
Go to EDIT
Paste Special
Check "MULTIPLY"
Press OK

Hardeep kanwar