Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing Multiple Hyperlinks (Excel 2003)

    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: Removing Multiple Hyperlinks (Excel 2003)

    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.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing Multiple Hyperlinks (Excel 2003)

    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

  4. #4
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing Multiple Hyperlinks (Excel 2003)

    Hi Hans,

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •