Macro - hyperlinks + add-in

**Snarf** · 06-05-2009, 09:41 AM

I am trying to figure out how to make a macro remove hyperlinks and make it an add-in.

Anyone know?

**dominicb** · 06-05-2009, 09:47 AM

Good morning Snarf
...and welcome to the forum!!

Originally Posted by Snarf

I am trying to figure out how to make a macro remove hyperlinks and make it an add-in.

All hyperlinks in the workbook, or all hyperlinks in the worksheet only? Or just the hyperlink in a selected cell? Is the text to stay behind?

This simple macro will remove all hyperlinks in the currently active workbook :

Sub test()
For Each WkSht In ActiveWorkbook.Worksheets
WkSht.Activate
Cells.Hyperlinks.Delete
Next WkSht
End Sub

HTH

DominicB

**Snarf** · 06-05-2009, 10:57 AM

That will work, or just the active worksheet (I have that macro), either one.

But I create a new workbook every week, so I don't want to have to keep recreating the macro on the file. There's a way to save the macro as an add-in so that it can be accessed in any excel file, I just can't find it.