How to assign a text hyperlink to a macro???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ladies and gentlemen,

Do you know how to assign a hyperlink to a macro. I have some text, I would
like to create a hyperlink for that text, then when I click over that text,
the hyperlink will cause my assigned macro to run....

I've look through Powerpoint for hours but I could find any way to realize
my idea...

Many thanks for your help..

Best regards,
Hao.
 
Select the text
Right click
Action Setting
On Click
Your Macro Name
OK


--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..
 
I don't know anything VB coding.. but can't you just write the hyperlink into
the macro? Extend the functionality of your macro to include a hyperlink to
the slide you want... this way you only need to assign a macro in the Action
Settings.
 
Oh.. do you think he just wanted to run a macro? I took his question to mean
that he wanted to go to another slide and at the same time execute a macro.

Has your question been answered Tran Duy Hao?
 
Dear Bill,

It's wonderful... I remmeber that I went to "action setting" some times but
why I couldn't find that point... I need to check my eyes again...hehehe...

I would like to send you many thanks for your help... You are number one,
Bill...

By the way, I have another problem, and you could be able to help me another
time, I belive...

In my slide, I added a command button and I want its background to be
transparent, I then set it Backstyle property to 0-fmBackstyleTransparent.
But when I run my slide (F5), it goes back to its original color, not
transparent anymore....

To double check this problem, I created 2 command buttons named
CommandButton1 and CommandButton2, and then put the following code under
CommandButton2:

Private Sub CommandButton2_Click()
CommandButton1.BackStyle = fmBackStyleTransparent
End Sub

....and then set the breakpoints each line of the above code, while running
my slide and then click on the CommandButton2, I noticed that the Backstyle
value of CommandButton1 change from 1 to 0 (that means change from Opaque to
Transparent) but when looking at m,y slide, nothing happened to the backstyle
of the CommandButton1...


Do you have any idea about this, Bill??? could you please help me to solve
out this problem... Again, It's really appreciated...

All my best regards,
Hao.
 
Thank you very much for your idea, Dawgma...

However, I've got another easier way to do this from Bill, as below:
....
Select the text
Right click
Action Setting
On Click
Your Macro Name
OK
--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
....

Anyway, thank you very much for your help, dear Dawgma...

Wish you all the best...
Hao.
 
This is a known bug/problem/glitch with ActiveX command shapes on slides.
They do not become or stay transparent.

You can make a regular autoshape, than attach an action setting to call a
macro (just like the previous question).
The advantage of using this method is that the autoshape will be able to be
made transparent, and will function like a command button.


--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..
 
Dear Bill,
It's excellent... Your advice is really working good... many thanks for all
that...

One more point, now I created 2 autoshapes assigned to 2 macros named
"Forward" and "Back". and it's working very well. Now I would like to disable
the funtions of the mouse outside the surface of these two autoshapes. mean
if I click my mouse any point apart from these 2 autoshapes, nothing will
happen...

what is the solution for this, Bill???

many thanks again for your help...

Best regards,
Hao.
 
One more thing, Bill..

When I inserted my userform. the controls toolbox for that Form only show
some basic controls (command button, image, text, label...). I would like to
add more controls to that toolbox but when I right-click over the toolbox,
and then select "Additional Controls..." but nothing happened...

I remember I did the same way with VBA in Excel before and I had a menu
opened which showed me more controls to select. But now I go back to Excel
and Word and do the same thing but nothing happened...

Could you please advise in this case, Bill?

Thanks very much...

Best regards,
Hao.
 
Back
Top