Hyperlinks in Excel 2003

[r1947]

Hi all: Is it possible to download from the internet into Excel 2003, once
saved to remove the ‘Hyperlink’ in one go, at the moment I have to do ‘Remove
Hyperlink’ at one cell at a time. Question how to remove all Hyperlinks’ in
one ‘Select All’ and then away to remove all in one or two clicks. Thanks to
all who can help.

 

[Gary''s Student]

Try this tiny macro:

Sub r1947x()
ActiveSheet.Hyperlinks.Delete
End Sub

 

[r1947]

Thank you for your prompt reply, I would not know where to start to try your
small macro, like where to write a macro or where to put it if i could.
looked at all custum buttons to put on menu bar, but no luck there either.
But thank you for your idea.

 

[Gary''s Student]

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To use the macro from the normal Excel window:

1. ALT-F8
2. Select the macro
3. Touch Run



To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

I suggest that you try this on a copy of your "real" worksheet to insure you
will be happy with the results.

If you want to go this route, update this post and I will show you how to
assign a shortcut key to run the macro or how to add either a buttton or menu
item to run the macro.

 

[r1947]

Thank you Gary for all your help I will take your advise and read more about
macro's if I still cannot get to grips with it I will just have to grin and
bare it. and delete one at a time as I have been doing in the past. But thank
you again for you time I will use your link you gave me to www.mvps.org and
maybe find a book in WH Smith's on the subject Iwill sing off now but thank
you and good luck to your future your a star... from Ray

 

[Gary''s Student]

Thanks for the feedback! Remember if you try this on a sample worksheet, you
have nothing to lose (except perhaps 15 minutes).