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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |