Removing Multiple Hyperlinks (Excel 2003)

[cabratt]

I have a client who has a very large spreadsheet with hyperlinks and he would like to remove the hyperlinks all at one time. Is there a way to do this in Excel? Any help will be appreciated. Thank you in advance.

[HansV]

If he would like to turn the hyperlinks into ordinary text values:
- Activate the Visual Basic Editor (Alt+F11)
- Activate the Immediate window (Ctrl+G)
- Type ActiveSheet.Hyperlinks.Delete and press Enter.

I he wants to clear all the cells containing hyperlinks, he'd need a macro.

[cabratt]

Hi Hans,

I followed your steps on one of my spreadsheets and it didn't work for me. When I did CTRL + G I couldn't see that anything happened and I typed the text but the hyperlinks were still active. What am I doing wrong?
Thank you for your help.

Carol

[cabratt]

Hi Hans,

I spoke too soon. The macro worked very well for me. Thank you again!!
Carol