Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Using mouseover action to run a macro in Powerpoint

1,032 views
Skip to first unread message

Frank Davoli

unread,
Aug 16, 2002, 1:50:44 PM8/16/02
to
I am trying to run a macro whenever a mouseover action occurs while in
Slide Show mode. I can run the macro from the "Macros" window when I
click the Run button, but it doesn't work when I choose to run it from
either the "Mouseover" Event or the "Mouse Click" Event Action
Settings.

Steve Rindsberg

unread,
Aug 16, 2002, 6:00:39 PM8/16/02
to
Odd. Are the macros in a different PPT file, perhaps?
Macros/Run lets you choose from among the macros in all open presentations.
Mouse events want the macro to be in the current presentation.

--
Steve Rindsberg PPT MVP
PPT FAQ: http://www.pptfaq.com
PPTools: http://www.pptools.com
"Frank Davoli" <fda...@osec.com> wrote in message
news:68f19b9c.02081...@posting.google.com...

Frank Davoli

unread,
Aug 19, 2002, 5:03:44 PM8/19/02
to
Thanks for the reply, Steve. The macro is in the same presentation.
When I set the Slide Show Action Settings for a particular shape, I
can play a sound and/or hilite the shape, but I cannot run a macro
for either the Mouse Click or Mouseover events. I just want a shape
to change color when I pass the mouse over it, and I would think that
this is a common procedure. I also just tried this on someone else's
computer and got the same results, so obviously I'm overlooking
something.

Steve Rindsberg

unread,
Aug 20, 2002, 9:48:08 AM8/20/02
to
Check your security settings first - if PPT is set to high security, it'll
open your presentation but disable macros w/o even a message to you. It
sounds like this might be the problem.

If not, post the code in your macro and describe how you're setting up the
action to run it.

--
Steve Rindsberg PPT MVP
PPT FAQ: http://www.pptfaq.com
PPTools: http://www.pptools.com
"Frank Davoli" <fda...@osec.com> wrote in message
news:68f19b9c.02081...@posting.google.com...

Frank Davoli

unread,
Aug 22, 2002, 1:04:15 PM8/22/02
to
Thanks again, Steve.

I am prompted to enable or disable macros when I open the file, so I
choose to enable. The security was set at "medium", so I tried
setting it at "low" and it still didn't work. I even tried saving the
file, closing it, and reopening it to see if that might be the
problem.

In order to hilite a shape (rectangle) with a different color, I first
recorded a macro by choosing "Tools/Macro/Record new macro", "OK",
then I selected a rectangle and colored it a different color, and then
I chose "Tools/Macro/Stop Recording". I then returned the shape to
its original color, and while it was selected, I chose
"SlideShow/Action Settings", selected the "Mouseover" tab, selected
the radio button "Run Macro", clicked on the drop-down list arrow,
chose the macro that I had just recorded, and clicked "OK". I've also
tried the same procedure using the "Mouse Click" tab, and neither way
works when in SlideShow mode.

I've tried checking the checkbox to play a sound, and the other
checkbox to highlight from both the 'Mouse Click" tab and the
"Mouseover" tab, and those all work when in slideshow mode.

The code is very simple. Here it is:


Sub Macro1()
'
' Macro recorded 8/16/02 by Frank Davoli
'

ActiveWindow.Selection.SlideRange.Shapes("Rectangle 79").Select
ActiveWindow.Selection.ShapeRange.TextFrame.TextRange.Select
With ActiveWindow.Selection.ShapeRange
.Fill.ForeColor.RGB = RGB(255, 204, 153)
.Fill.Visible = msoTrue
.Fill.Solid
End With
ActiveWindow.Selection.Unselect
End Sub

Steve Rindsberg

unread,
Aug 22, 2002, 2:57:18 PM8/22/02
to
Thanks for the detailed description, Frank.

Things you record in normal or slide view don't always work in slide show
view; selecting stuff never works.
Read this 'un to learn more:

Macros I record in Normal/Slide view don't work in Slide Show
http://www.rdpslides.com/pptfaq/FAQ00159.htm


0 new messages