I have 280 hyperlinks in Excel 2007 worksheet which I want to delete without
having to do each one manually. Does anyone know a short cut that will
delete them all in a few key strokes? Many thanks in anticipation

Execute the following macro :

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

HTH
Daniel

> I have 280 hyperlinks in Excel 2007 worksheet which I want to delete without
> having to do each one manually. Does anyone know a short cut that will
> delete them all in a few key strokes? Many thanks in anticipation

Click Edit-Find and in the options choose the format from a cell with a
hyperlink, click find All, select all cells by pressing ctrl+A then press
delete.

"Jane" wrote:

> I have 280 hyperlinks in Excel 2007 worksheet which I want to delete without
> having to do each one manually. Does anyone know a short cut that will
> delete them all in a few key strokes? Many thanks in anticipation

Thanks for your prompt reply. I found by selecting a cell without a
hyperlink then using the FORMAT PAINTER and highlighting the column, it
removed all the hyperlinks.

"Daniel.C" wrote:

> Execute the following macro :
>
> Sub test()
> ActiveSheet.Hyperlinks.Delete
> End Sub
>
> HTH
> Daniel
>
> > I have 280 hyperlinks in Excel 2007 worksheet which I want to delete without
> > having to do each one manually. Does anyone know a short cut that will
> > delete them all in a few key strokes? Many thanks in anticipation
>
>
>

Many thanks

"Lori" wrote:

> Click Edit-Find and in the options choose the format from a cell with a
> hyperlink, click find All, select all cells by pressing ctrl+A then press
> delete.
>
> "Jane" wrote:
>
> > I have 280 hyperlinks in Excel 2007 worksheet which I want to delete without
> > having to do each one manually. Does anyone know a short cut that will
> > delete them all in a few key strokes? Many thanks in anticipation

You sure that the hyperlink was deleted?

Or was the cell formatted so it look like the hyperlink was deleted?

Jane wrote:
>
> Thanks for your prompt reply. I found by selecting a cell without a
> hyperlink then using the FORMAT PAINTER and highlighting the column, it
> removed all the hyperlinks.
>
> "Daniel.C" wrote:
>
> > Execute the following macro :
> >
> > Sub test()
> > ActiveSheet.Hyperlinks.Delete
> > End Sub
> >
> > HTH
> > Daniel
> >
> > > I have 280 hyperlinks in Excel 2007 worksheet which I want to delete without
> > > having to do each one manually. Does anyone know a short cut that will
> > > delete them all in a few key strokes? Many thanks in anticipation
> >
> >
> >

--

Dave Peterson