Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlinks (Excel 2000 (SR-1))

    How do I turn off hyperlinks for a sheet, or better yet, an entire workbook?

    I'm rebuilding an eMail server & have to organize several thousand eMail addresses.
    Excel is the easiest way for me to do this, but I don't want the hyperlinks.
    I have to show the eMail address correctly because I'll be presenting the organized scheme to people who aren't computer literate and I don't want to explain repeatedly that the reorganized addresses don't contain spaces (the only way that I've found to defeat automated hyperlinking).
    Help!

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Hyperlinks (Excel 2000 (SR-1))

    Hi,
    I'd say that the easiest way would be to enter your email addresses ignoring the fact that Excel turns them into hyperlinks, and then run a macro using the line
    activesheet.hyperlinks.delete
    to remove all the hyperlinks.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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