remove Hyper Links - PPT 2007

Post Reply

	Author	Message

jessekaye

Newbie

Joined: Wed Mar 10, 2010 12:10 am
Posts: 1

Posted: Wed Mar 17, 2010 8:34 pm Post subject: remove Hyper Links - PPT 2007

Hi,

I have hyper link in 42 slides of my PPt (2007) and most of them have hyperlink to an excel. Is there any way that i can remove all the Hyper links in one go, without changing the formats of the slides?

can anyone help me on this?

profile test

Aleksey Malov

iSpring Team

Joined: Sat Mar 24, 2007 11:45 am
Posts: 205

Posted: Thu Mar 18, 2010 7:54 am Post subject: Re: remove Hyper Links - PPT 2007

In case you are familiar with Visual basic macros you may use something like this:

Code:

Sub RemoveHyperlinks()

    For i = 1 To ActivePresentation.Slides.Count
        Dim sld As Slide
        Set sld = ActivePresentation.Slides(i)
            
        For j = sld.Hyperlinks.Count To 1 Step -1
            Dim h As Hyperlink
            Set h = sld.Hyperlinks(j)
            
            h.Delete
        Next j
    Next i

End Sub

This macro, however, does not remove hyperlinks which are applied to a part of the text (for example to one of several paragraphs). However, they can also be removed if you improve the macro a bit.

profile test

www

ICQ

Post Reply

Who is online
	In total there are 8 users online :: 2 registered, 0 hidden and 6 guests (based on users active over the past 5 minutes) Most users ever online was 108 on Thu Nov 21, 2013 3:41 pm Registered users: Bing [Bot], Google [Bot]