We love PowerPoint at BrightCarbon. It’s such a versatile application which can be used for so much more than ‘just’ designing presentations. You can create videos, printed collateral, interactive eLearning, even animated GIFs and so much more. But did you know you can even create games? We’ve built one for you, using VBA, and it’s free to download and adapt.
Believe it or not, sometimes things go wonky in the world of PowerPoint (gasp!). One particularly frustrating quirk we come across is when the Notes Pages layout gets out of sync. Sometimes the slide, notes and number placeholders change size or move from where you’ve told them to be in the Notes Master. So, we’ve developed a little VBA macro which fixes it for you in a snap.
Learn how to use the Notes Master to print PowerPoint with notes.
The Notes Master is on the left in the screenshot below. This defines where the three placeholders (slide, notes, slide number) are positioned and what size they should be. However, on the right you can see the Notes Page for one of our slides – it’s not following the master.
Though it’s frustrating, it’s pretty simple to correct. All you need to do is open the Notes Page for your slide by clicking the View tab in PowerPoint followed by Notes View. Once in this view you can right–click on the Notes Page and choose Notes Layout:
This gives you the option to Reapply master, for the current slide:
And hey presto, all fixed:
But did you spot the gargantuan problem??
It resets the CURRENT slide only! Oh dear. Cue hours of tedious work for those huge presentation projects with tens if not hundreds of slides.
Don’t worry, you can wave RSI goodbye because Captain VBA is here to save the day.
If you’ve never used VBA before, check out our getting started article. If you have used VBA in PowerPoint and you know how to throw some VBA at your presentation, here’s our handy macro for fixing wonky Notes Pages:
Just copy paste the VBA below into a code module and run it from PowerPoint by pressing Alt+F8 and double clicking the macro.
Sub RestoreNotesPages() Dim oSld As Slide Dim oShp As Shape Dim lIdx As Long On Error Resume Next With ActivePresentation For Each oSld In .Slides With oSld.NotesPage.Shapes ' Delete the objects from the notes page in reverse order For lIdx = .Count To 1 Step -1 .Item(lIdx).Delete Next DoEvents ' Recreate the placeholder objects on the notes page .AddPlaceholder ppPlaceholderTitle .AddPlaceholder ppPlaceholderBody .AddPlaceholder ppPlaceholderSlideNumber End With Next End With End Sub
So, there you have it! A big automation time saver that lets you get on with far more interesting presentation tasks than the monotony of manually resetting your notes pages, one slide at a time.
What other tasks you ask? Well, why not add sensational slide transitions or a sleek mobile phone media holder to your next deck? For more PowerPoint design ideas, check out the rest of our blog.Leave a comment
Senior technical consultantView Jamie Garroch's profile
Pictures in PowerPoint can be tricky to get to grips with. Choosing the right size has an impact on both the file size of your presentation and the maximum monitor/projection size you can use without degrading quality.
How do you make sure the presentations, spreadsheets and documents your create in Microsoft Office are kept in line with your brand? Learn how to create, save and deploy a custom Office theme across PowerPoint, Excel and Word.
First of all the deck looks great, once again you guys have done an outstanding job. Second, I’d like to comment on the quality of the training provided by your colleagues - quite simply it was exceptional. I have spoken to the whole team and that view is unanimous. Please pass this on.James Bagan MyLife Digital