hyperlinks

P

Pascale

Hello
I work with Excel 2000. I have a spreadsheet with a lot of hyperlinks that I
would like to remove in one go if possible. I have tried selecting the link
and copy, paste special, value (ie not format) but it does not work. Any
suggestion?
Many thanks
Pascale
 
S

Sarah_Lecturer

Hope this helps:

Select all the cells
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.
 
C

Carim

Hi Pascale,

Solution from Dave :

1. Select all the cells
2. hit alt-F11 (to get to the VBE, where macros live)
3 .hit ctrl-g (to see the immediate window)

type this and hit enter:

Selection.hyperlinks.delete

Close the VBE and back to Excel

HTH
Cheers
Carim
 
P

Pascale

It worked!!! thanks you so much. Could you please tell me which training I
would need todo to know all this (I've got my MOS master already)? THANKS
 
P

Pascale

It worked!!! thank you so much. Could you please tell me which training I
would need to do to know all this (I've got my MOS master already)? THANKS
 
C

Carim

Pascale,

In my very humble opinion, practice and the news group are far better
.... !!!

Cheers
Carim
 
Top