VBA and hyperlinks in table cells

viuf · #8 02-19-2012, 05:34 AM

Simpel and yet exactely what I was looking for. Thank you

In addition to that I have to related questions that I hope you (or other) can help me with.

1. How can I format the look of these links so they are not just blue and underlined?

2. How do I send a variable with the link to the new sub?

What I mean is if I remove the IF-part so I get a link in every cell, how can I make each link differet? iRow changes for every cell, so I would like this variable to be send to the next sub, depending on wich cell is pressed, and the value used there.

Code:

                With .ActionSettings(ppMouseClick)
                .Action = ppActionRunMacro
                .Run = "GoToSlide(iRow)"
                End with

 
Sub GoToSlide(page as integer)
    ActivePresentation.SlideShowWindow.View.GoToSlide (page)
End Sub

the GoToSlide sub is not what I'm going to use later, just to get an idea of how to re-use the variables.

Thanks again

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word VBA: add textboxs in table cells?	tinfanide	Word VBA	12	02-09-2012 12:05 AM
put a border around table cells that have text in them	tonywatsonmail	Mail Merge	1	01-31-2012 04:37 AM
Unwanted tabs in table cells	deltaskye	Word	5	01-27-2012 11:58 AM
Combining Text from Table Cells	robmorleyuk	Word	1	11-01-2011 07:24 AM
Word with frames, table of contents, and hyperlinks to html	NHMC	Word	0	12-09-2009 12:54 PM