Excel Database
 

I have a huge database - because I have had to add rows and columns I now
have hyperlinks embeded throughout the database. This is a pain because I'm
always opening a website or email. How do I remove ALL OF THESE at one time?
This database is to row EE and 9000 lines long. Trying to remove these one
at a time is not an option
--
seb

Select the range to clean up
(ctrl-a (twice in xl2003) will select the whole sheet.)
then hit alt-f8 (to get to the VBE)
then hit ctrl-g (to see the immediate window)

type this and hit enter
selection.hyperlinks.delete

Then back to excel to see what happened.

Shirley wrote:

I have a huge database - because I have had to add rows and columns I now
have hyperlinks embeded throughout the database. This is a pain because I'm
always opening a website or email. How do I remove ALL OF THESE at one time?
This database is to row EE and 9000 lines long. Trying to remove these one
at a time is not an option
--
seb

--

Dave Peterson

The reply by Dave Peterson did not work - it locked everything up - any other
suggestions? also it was control F12 to get to that window - I'll try it
again and see what happens
--
seb


"Shirley" wrote:

I have a huge database - because I have had to add rows and columns I now
have hyperlinks embeded throughout the database. This is a pain because I'm
always opening a website or email. How do I remove ALL OF THESE at one time?
This database is to row EE and 9000 lines long. Trying to remove these one
at a time is not an option
--
seb

Do you have lots and lots and lots of hyperlinks.

Maybe you could do it in steps.

Select columns A:E (or whatever you feel might work)
then do that stuff.

By the way, ctrl-F12 opened the file|open dialog for me.

You want to try a macro that tries it one column at a time:

Option Explicit
Sub testme()
Dim iCol As Long
With ActiveSheet
For iCol = 1 To .Columns.Count
.Columns(iCol).Hyperlinks.Delete
Next iCol
End With
End Sub

Ps. I've never seen that other suggestion fail. But I have seen other stuff
fail if there were too many things to be deleted.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Shirley wrote:

The reply by Dave Peterson did not work - it locked everything up - any other
suggestions? also it was control F12 to get to that window - I'll try it
again and see what happens
--
seb

"Shirley" wrote:

I have a huge database - because I have had to add rows and columns I now
have hyperlinks embeded throughout the database. This is a pain because I'm
always opening a website or email. How do I remove ALL OF THESE at one time?
This database is to row EE and 9000 lines long. Trying to remove these one
at a time is not an option
--
seb

--

Dave Peterson