PowerPoint and Excel Highlighting

[Sue]

I have an Excel spreadsheet where I keep all of our change management items.
Once a week we get together and talk about them. Each person talks about
their own change. We usually have 10 or more items to discuss. I have created
a PowerPoint presentation and copied the Excel spreadsheet into a slide. I
would like to have a mouse click where I could highlight the row that we are
talking about. Then when we are going to the next item, the last highlight
goes away and the next item is highlighted. Any suggestions?

 

[Kathy J]

Sue,
If you are using PPT 2002 or 2003, you can use triggers to do this. What you
do is add boxes over each of the rows to highlight, then animate them to
appear and disappear. next add a series of hidden buttons for each of the
boxes you just added. Change the appearance animations to be triggered by
one of the hidden boxes and the disappearance to be triggered by the click
of the box itself. To learn more about triggers, check out the "Trigger
Happy Animations" article on my site:
http://www.powerpointanswers.com/article1056.html

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Sue]

Thank you, Kathy J. I will give it a try and let you know how it did.

 

[Sue]

It worked GREAT!!! Thanks, Kathy!

Sue,
If you are using PPT 2002 or 2003, you can use triggers to do this. What you
do is add boxes over each of the rows to highlight, then animate them to
appear and disappear. next add a series of hidden buttons for each of the
boxes you just added. Change the appearance animations to be triggered by
one of the hidden boxes and the disappearance to be triggered by the click
of the box itself. To learn more about triggers, check out the "Trigger
Happy Animations" article on my site:
http://www.powerpointanswers.com/article1056.html

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

 

[Kathy J]

Glad to hear it! Thanks for getting back to us!

It worked GREAT!!! Thanks, Kathy!