A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can a macro determine which hypertext link invoked it?



 
 
Thread Tools Display Modes
  #1  
Old June 23rd, 2005, 04:13 PM
hofferoo
external usenet poster
 
Posts: n/a
Default How can a macro determine which hypertext link invoked it?

I have several hypertext links in a shape's text that all invoke the same
macro. The macro can know which shape invoked it from the macro's one
argumnet. Can the macro determine which hypertext link invoked it?
THANKS!!
  #2  
Old June 23rd, 2005, 09:14 PM
Bill Dilworth
external usenet poster
 
Posts: n/a
Default

Dim RightHere as String

Sub RomeoRomeo(oSh As Shape)
RightHere = oSh.Name
ActivePresentation.FollowHyperlink oSh.Tags("PseudoLink")
End Sub

If you set the shape to fire the action setting macro RomeoRomeo it will
send you to the address stored in the shape tag "PseudoLink" with the string
RightHere telling you the name of the shape that was clicked to send it.

"hofferoo" wrote in message
...
I have several hypertext links in a shape's text that all invoke the same
macro. The macro can know which shape invoked it from the macro's one
argumnet. Can the macro determine which hypertext link invoked it?
THANKS!!



  #3  
Old June 24th, 2005, 04:10 AM
Shyam Pillai
external usenet poster
 
Posts: n/a
Default

Only shape level information is passed to the macro. I cannot think of
anyway to arrive at the textlink within the shape which was responsible for
the macro being fired without resorting to creating invisible shapes over
the text areas.


--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how




"hofferoo" wrote in message
...
I have several hypertext links in a shape's text that all invoke the same
macro. The macro can know which shape invoked it from the macro's one
argumnet. Can the macro determine which hypertext link invoked it?
THANKS!!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy cell format to cell on another worksht and update automatical kevinm Worksheet Functions 21 May 19th, 2005 11:07 AM
Link to Excel problem Jeff General Discussion 0 July 21st, 2004 02:00 AM
Link to Excel from Outlook message Jeff General Discussion 0 July 18th, 2004 06:37 PM
A hypertext link to an Excel documents (questions) Robert General Discussion 3 June 22nd, 2004 11:59 PM
Too many hyperlinks? [email protected] Powerpoint 7 May 25th, 2004 02:19 AM


All times are GMT +1. The time now is 07:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.