+ Reply to Thread
Results 1 to 3 of 3

Thread: Macro code to remove all the Hyperlinks from a worksheet.

  1. 04-02-2009, 09:47 AM #1
    robertguy
    robertguy is offline
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    Posts
    185

    Thumbs up Macro code to remove all the Hyperlinks from a worksheet.

    Hi,

    What I’m after is the macro code to remove all the Hyperlinks from the data in the cells in a worksheet.

    Any assistance would be greatly appreciated


    Regards

    Bob

    Excel version 2003
    Last edited by robertguy; 04-03-2009 at 07:00 AM. Reason: robertguy
    Rob
    Reply With Quote Reply With Quote
  2. 04-02-2009, 10:43 AM #2
    tweek333
    tweek333 is offline
    Registered User
    Join Date
    01-23-2009
    Location
    wolverhampton, england
    MS-Off Ver
    Excel 2000
    Posts
    16

    Re: Macro code to remove all the Hyperlinks from a worksheet.

    code as follows

    Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Sub
    thx

    Tw
    Reply With Quote Reply With Quote
  3. 04-02-2009, 10:58 AM #3
    robertguy
    robertguy is offline
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    Posts
    185

    Thumbs up Re: Macro code to remove all the Hyperlinks from a worksheet.

    tweeek333

    many thanks for your prompt reply its works as requested


    Many thanks

    Regards


    Rob
    Rob
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0