Remove multiple hyperlinks from an Excel file in one operation

pubbuddy
pubbuddy used Ask the Experts™
on
Is it possible to remove all hyperlinks from an Excel file in one operation?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
hi

try this code
Sub Hyperlinks()
 
Dim z As Range
On Error Resume Next
Set z = Application.InputBox("Select your Range", Type:=8)
If z Is Nothing Then Exit Sub
 
z.Select
Selection.Hyperlinks.Delete
 
Range("A1").Select
 
End Sub
hi
Removing multiple hyperlinks from Excel file can be very frustrating - since Excel doesn’t have a feature that would allow to do it right away.

Here is a simple trick that will help you with that:
1. Type 1 in a blank cell
2. Right-click and select Copy on the context menu.
3. While pressing CTRL, select each hyperlink you wish to be removed (selecting the whole row or column will do)
4. On the Edit menu, select Paste Special.
5. Under Operation, click Multiply and then click OK.
by
kumaresan
hi
other technic for removing hyperlink from excel sheet
Remove Excel hyperlinks on selected cells the better way
1. Type in any text or number in a blank cell
2. Right-click and select Copy on the context menu.
3. While pressing CTRL, select each cell with the hyperlink you wish to be removed
4. On the Edit menu, select Paste Special.
5. Under Operation, click Multiply and then click OK.
6. If you are using Office 2007, you may need to click or change the cell format to Normal found at the Styles Group Toolbar.

Removing Excel hyperlinks using a macro
Assuming you know excel programming you could create a macro to automatically remove the hyperlinks.
1. Start Visual Basic Editor. Alternatively you can press ALT-F11 to start the editor.
2. Double click the workbook you are using on the Project Explorer.
3. Type the following text:

Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

4. Save your work.
5. Run your macro by pressing ALT-F8 or using the menu by Tools->Macro->Macros
6. Select the macro you have made, it should have the name 'RemoveHyperlinks'.

by
kumaresan

Author

Commented:
I did not use the one. It is not that it was not good.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial