PDA

View Full Version : Macros On A Page



EdenC
05-16-2011, 01:59 AM
Hi Guys,

How Do I Make A Certain Macro Run Everytime A Certain Powerpoint Slide Is Seen (Powerpoint 2007).

If You Need More Info Please Tell Me!

Thanks,
Eden

John Wilson
05-16-2011, 08:38 AM
The correct (reliable) way is to create a with events class object. This is not straightforward there's an example here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=327 (http://www.vbaexpress.com/forum/../kb/getarticle.php?kb_id=327)
Chirag Dahl has a much simpler way here:
http://officeone.mvps.org/vba/run_macro_at_slide.html
HOWEVER this is not reliable in 2007 once you save and reopen PowerPoint. One way to improve reliabilty is to have slide one with NO click transition and a button to click which moves to the next slide with code
SlideShowWindow(1).View.GoToSlide(2) This seems to kick the codebase into action!