Solved

Print 1 Powerpoint Slide From Macro

Posted on 2012-03-16
2
857 Views
Last Modified: 2012-06-27
I have a Power Point presentation and I have put a printer image in the lower right corner. The top slide has "Buttons" with hyper links to each slide. I'd like to put a macro behind the printer image so that when the show is running and the user clicks on the image, THAT SLIDE only will print.

Thanks.
0
Comment
Question by:Buck_Beasom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Accepted Solution

by:
JSRWilson earned 500 total points
ID: 37731125
This macro should do it.

Sub printMe()
Dim lngSld As Long
lngSld = SlideShowWindows(1).View.Slide.SlideIndex
With ActivePresentation.PrintOptions
.Ranges.ClearAll
.RangeType = ppPrintSlideRange
.Ranges.Add Start:=lngSld, End:=lngSld
End With
ActivePresentation.PrintOut
End Sub

Open in new window


Don't be tempted by:
.RangeType=ppPrintCurrent which sounds correct but prints the current slide in EDIT view (not always the same) Also you must clear any old Ranges or they will also print.
0
 

Author Closing Comment

by:Buck_Beasom
ID: 37739714
Outstanding! Thanks.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
A lot of things can happen during a presentation, worst of which is “death by PowerPoint.” Here are a few mistakes to avoid to make your slides clean.
The viewer will learn how to edit the master slide. They will also learn how to combine multiple themes into one master slide to use them in their presentation.
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question