Saturday, June 26, 2010

Macro to Remove Hyperlinks from Cells

If you want to remove hyperlinks from multiple cells together . Try this code

Sub hyperlinkbyselection()
     Selection.Hyperlinks.Delete
End Sub





Steps to Use



  • Copy the below code
  • Press Alt+F11 to open VBA editor
  • Paste it in any public module or module 1
  • Select the cells & run the Macro

No comments:

Post a Comment

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...