You'd want a macro (or two) that does:

Option Explicit
Sub DeleteHyperLinksFromSelection()
Selection.hyperlinks.delete
End Sub
Sub DeleteAllHyperLinks()
activesheet.cells.hyperlinks.delete
End sub

Then you could use alt-f8 to invoke either macro.

If you want an item on the addins tab (in xl2007):

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

In xl2007, those toolbars and menu modifications will show up under the addins.

M wrote:

Dave - Your VBE to select a section of hyperlinks and delete them works
great!:-) I would like to include this as a VBA sub (macro) and put it into
my tool bar or ribbon or other easly accessed button in Excel 2007 but I am
VBA/E/Macro challenged but can follow explecit directions and have other
add-ins and macros that I have managed to "add-in" could you help me with
creating the VBA sub (macro) to do this?
Thank you,
M

"Dave Peterson" wrote:

Select all the cells (ctrl-A (twice in xl2003))
hit alt-f11 (to get to the VBE, where macros live)
hit ctrl-g (to see the immediate window)

type this and hit enter:

selection.hyperlinks.delete

Close the VBE and back to excel to see if it worked.

===
You could even just select a smaller range and just clean that since the command
uses the current selection.

davey wrote:

--

Dave Peterson


--

Dave Peterson