 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / September 2007VBA Auto-run
Hi, Can anyone tell me how I can get some VBA to run when a presentation is shown or when a slide appears without the user doing anything? There doesn't seem to be an onOpen or onLoad method for either a slide or a presentation like there is in other Office products. Many thanks Paul, You have to understand the difference between opening a presentation and viewing it. In the view mode, you will have to build your own event handler to automate code. Austin Myers MS PowerPoint MVP Team Provider of PFCPro, PFCMedia and PFCExpress www.playsforcertain.com > Hi, > [quoted text clipped - 6 lines] > > Many thanks Thanks for the response. I appreciate there is a difference and, in fact, I'd like to be able to automate both modes (edit and view) in the future. At the moment, though, it's view mode I'm interested in. > Paul, > [quoted text clipped - 18 lines] > > > > Many thanks > Can anyone tell me how I can get some VBA to run when a presentation is > shown or when a slide appears without the user doing anything? > > There doesn't seem to be an onOpen or onLoad method for either a slide or a > presentation like there is in other Office products. An event handler can detect when a user's moved to a new slide, but as you've found, you can't get code to run on opening a presentation. Normally you'd put an event handler in an add-in, but that would require that it be installed on every pc where you want the show to work. Another trick that might work is to start the presentation with an introductory starting slide. On it, you have a "Start the show" button the user can click. This triggers a macro that loads the event handler and moves to the next slide. That'll get you around having to install an add-in, but it won't work unless the user's macro security settings permit macros to run, something you can't be sure of usually. Also, macros don't work in the free Viewer. More on event handlers: Make PPT respond to events http://www.pptfaq.com/FAQ00004.htm ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Many thanks - this looks like what I'm looking for, although it's a shame you have to do this stuff via an add-in. Oh well, maybe in PPT 3001...... Paul > > Can anyone tell me how I can get some VBA to run when a presentation is > > shown or when a slide appears without the user doing anything? [quoted text clipped - 26 lines] > PPTools: www.pptools.com > ================================================ > Many thanks - this looks like what I'm looking for, although it's a shame you > have to do this stuff via an add-in. Oh well, maybe in PPT 3001...... Nah. It'll just be harder than ever to get even an add-in to run any code. Always the optimist, ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ > > Many thanks - this looks like what I'm looking for, although it's a shame you > > have to do this stuff via an add-in. Oh well, maybe in PPT 3001...... > > Nah. It'll just be harder than ever to get even an add-in to run any code. > > Always the optimist, To the optimist, the glass is half full To the pessimist, the glass is half empty To the engineer the glass is twice as big as it needs to be Me? I think it's time to get another round of drinks! > > > Many thanks - this looks like what I'm looking for, although it's a shame you > > > have to do this stuff via an add-in. Oh well, maybe in PPT 3001...... [quoted text clipped - 7 lines] > To the engineer the glass is twice as big as it needs to be > Me? I think it's time to get another round of drinks! And to the pessimist, all surprises are pleasant ones. Especially when some guy shows up with another glass. Full or not. <g>
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.