We have moved to www.dataGenX.net, Keep Learning with us.

Wednesday, March 20, 2013

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()
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’.