My PowerPoint Macros by Andrew Noske http://www.andrewnoske.com/ Contents вЂў вЂў вЂў вЂў вЂў вЂў вЂў вЂў вЂў Introduction Running Macros Using these Macros in another PowerPoint document Problems Running Macros Using Macros across PowerPoint documents Attaching/copying Macros in another PowerPoint Doc Editing Macros Signing Macros Final Words Introduction вЂў This PowerPoint has several useful Macros attached to it. вЂў To access these Macros click: вЂ“ Tools >> Marco >> Marcos [Alt+F8] (on the toolbar) вЂ“ From here you can run, edit, create & delete Macros. вЂ“ TIP: get use to pressing [Alt+F8] Running Macros вЂў To run Macros: вЂ“ If not already hit [Alt+F8] вЂ“ Click the macro you want and hit вЂњRunвЂќ вЂ“ WARNING: Generally speaking you cannot undo macros (especially in MS Excel) and so itвЂ™s a good idea to save a backup before you run a new/unfamiliar Macro. Using these Macros in another PowerPoint document вЂў Instructions: вЂ“ Make sure this PPT document is open вЂ“ Open/create your own PPT document. вЂ“ Hit [Alt-F8] in your PPT document, and click Macro in: вЂњAll open presentationsвЂќ вЂ“ Select the one you want, hit вЂњRunвЂќ Problems Running Macros вЂў Sometimes you may find you canвЂ™t run Macros. This is to do with security settings, and a can be awkward to get around too. вЂў Easiest way around this is go: вЂ“ Tools >> Macros >> Security вЂ¦ >> Security Level, change the setting to вЂњMediumвЂќ and click OK. вЂ“ Close and reopen PowerPoint before it takes effect. вЂў A better method is to use/install certificates пѓ you do this under вЂњTrusted PublishersвЂќ tab пѓ to create you OWN certificate is harder вЂ“ you can read about it on the вЂњSigning MacrosвЂќ slide, or try Google. Disabled! Using Macros across PowerPoint documents вЂў Unlike MS Excel & MS Word, where you have a place to store/share Macros across ALL document, you cannot do the same in PowerPoint. вЂў I recommend writing all your Macros in a single PPT file (like this one)вЂ¦ and open this PPT whenever you wish to run Macros in another PPT. вЂў However, if you DO want to ATTACH the Macros code to a different document do the following (next slide)вЂ¦ Attaching/copying Macros in another PowerPoint Doc вЂў Instructions: вЂ“ Make sure this PPT document is open вЂ“ Open/create your own PPT document. вЂ“ Hit [Alt-F8] in your PPT document, type Marco name: вЂњwhateverвЂќ in and hit вЂњCreateвЂќ вЂ“ The Visual Basic editor will appear. вЂ“ In the Visual Basic editor, navigate to вЂњPowerPoint_Macros_ANвЂќ, select all [Ctrl+A] the code and copy it [Ctrl+C]. вЂ“ Navigate back to your new вЂњModule1вЂќ select all [Ctrl+A] and replace your вЂњwhatever вЂ¦вЂќ subroutine with my code. вЂ“ You can now close the Visual Basic Editor (it will save automatically) and then close this PPT document. Navigate Paste/edit code here Editing Macros вЂў To edit Macros: вЂ“ Click the macro and hit вЂњEditвЂќ вЂ“ Use the Visual Basic (VB) window to edit code. вЂ“ TIP: Before you play around read the instructions at the top of my code. вЂ“ Once done, you can save changes, run the subroutine you are editing or just close the VB window (it will save automatically) Save Run Signing Macros вЂў If you keep getting warning about Macros you can try using a digital signature. вЂў STEPS: 1. Go: Start >> Programs >> Microsoft Office >> Tools >> "Digital Certificate for VBA ProjectsвЂќ вЂў This runs a program called вЂњSelfCert.exeвЂќ (which lives in: C:\Program Files\Microsoft Office\OFFICE11\Cert.exe) 2. For certificate name type something like вЂњMyCertificateвЂќ. Click OK. вЂў You have just created your first вЂњdigital certificateвЂќ, and you can use this to sign VBA Projects. 3. Open the VB editor window and make sure the module/file you want to sign is open/selected. вЂў To get to here you can shortcut click [Alt+F11] from PowerPoint. 4. Click: Tools >> Digital Signatures >> Choose. Select the certificate you just created. OK your way out and save your file. вЂў The next time you open this particular file you shouldnвЂ™t get any warnings. Final Words вЂў Visual Basic is a babyish language, but hey вЂ“ Macros are cool! Macros can save you lots of time doing by automating repetitive tasks. вЂў Macro implementation in PowerPoint is not so bad, but actually I canвЂ™t think of THAT many tasks you wound want to automate in PowerPoint, so their use here is limited. вЂў Learning to use Macros in Excel and Word is much more valuable вЂ“ if you wish to learn Macros start with those! вЂў Visit http://www.andrewnoske.com/ for more cool stuff.