Microsoft PowerPoint

PowerPoint is a slide show presentation program currently developed by Microsoft. PowerPoint presentations consist of a number of individual pages or "slides" that may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. Slides can also form the basis of webcasts.

Share tech news, updates, or what's on your mind.

Sign up to Post

I usually stay away from PowerPoint's "Shrink text on overflow" setting for text boxes.  But I have an application where I want to use.  

But I am finding that it does not shrink the text enough.  When I set it to "shrink text," it reduces the size of the text, but not enough to fit into the text box.

Here's what I tried, in order
1. Original text 44 - box is set to "Do not autofit"
shrink12. Change to Shrink text on overflow - text reduces to 40 but does NOT fit into shape
shrink23. Manually shrink text to 36 - resets to "Do not autofit"
shrink34. Change again to Shrink text on overflow - text reduces to 32 (smaller than it needs to be)
I planning to execute this in VBA once I figure this out (myshape.TextFrame2.AutoSize = msoAutoSizeTextToFitShape).  

Do we just have to live with the fact that Shrink Text doesn't actually make the text fit inside the shape, or is there something else I can tweak to get it to behave like I want?  Thanks.
[Webinar] Learn How Hackers Steal Your Credentials
[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Hi expert,

I had a bunch of macros in PowerPoint macro enabled presentation 2010

How to create a PowerPoint Add-ins file for all my macros in a single ribbon with my custom icons.

Kindly Please Help me...
Hi Expert,

We are working in PowerPoint with huge of slides...

As per our standards we should not leave a single word at the end of the any paragraph and the bullet points. This would be very painful to mark while doing quality control

So I came to you for a help, I am trying to check at end of the all bulleted points and paragraph have a single word at last line
If it is there means I need to highlight that one via VBA...

Example 1: Pragraph have single wrap text
"This is a first sentence. This is a second

Example 2: Bullet point have single wrap text
•  how are

In above both example have a single word at end "sentence" and "you".. this need to highlight via vba

is it possible to do via VBA PowerPoint?
kindly any expert help me...
Hi Expert,

We are working in PowerPoint with huge of slides...

I am trying to check at end of the all bulleted points have Period, colon, Semicolon, and Comma are there or not. if it is there means I need to highlight that one via VBA... (because as per our standards we should not kept any puntuvation at end of the bullet points, this was very painful while doing quality control)

is it possible to do via VBA PowerPoint?
kindly any expert help me...
I have a question regarding PowerPoint, we are currently dealing with a very tough client, see email request below:

"So, the PP template is not 100% correct yet. For example; on pg. 2 – The background image and logo is locked down. A staff member won’t be able to move it. That’s perfect.
However, when you look at for example pg. 3 – You are able to move the background image around as well as the logo icon. This should not be allowed at all. This is what I am referring to as “locked down template”. J" She requested that the logo icon be on every page, but this specific page includes a full page image and I had to place the icon over the image as the image covers the slide master layout.
"The same applies for adding a new slide and making a section from the different layouts. For example when I select; 3_Custom Layout – Should the  block, ‘Click on icon to add picture’ be able to move?" She is referring to an editable block from a slide master slide.

I created the .potx with PowerPoint 2015 on Apple OS, and as far as I am aware locking layers on a slide master to be on top of other layers isn't a function? Please correct me if I am wrong. I also don't really know how to reply to this client.
I would like to Find the word {"keyword", "second", "third", "etc"} and highlight in Bold or yellow on all slide of the ppt. In shape, groupitem, table, chart, notespage etc. A below code works only in shape.

Could you please help me to modify the below code to work also in table, smartart, chart, notepage etc..

option Explicit

Sub HighlightKeywords()
Dim sld As Slide
Dim shp As Shape
Dim txtRng As TextRange, rngFound As TextRange
Dim i As Long, n As Long
Dim TargetList

'~~>  Array of terms to search for
TargetList = Array("keyword", "second", "third", "etc")

'~~> Loop through each slide
For Each sld In Application.ActivePresentation.Slides
'~~> Loop through each shape
For Each shp In sld.Shapes
    '~~> Check if it has text
    If shp.HasTextFrame Then
        Set txtRng = shp.TextFrame.TextRange

        For i = 0 To UBound(TargetList)
            '~~> Find the text
            Set rngFound = txtRng.Find(TargetList(i))

            '~~~> If found
            Do While Not rngFound Is Nothing
                '~~> Set the marker so that the next find starts from here
                n = rngFound.Start + 1
                '~~> Chnage attributes
                With rngFound.Font
                    .Bold = msoTrue
                    .Underline = msoTrue
                    .Italic = msoTrue
                    '~~> Find Next instance
                    Set rngFound = txtRng.Find(TargetList(i), n)
                End With
I've been developing PowerPoint add-ins using MS Office 2010 for years.  Yesterday I finally switched to 2016.  Made a few revisions today and re-saved as .ppam.  The .ppam file used to be 2.6MB and is now only 1.2MB.  Everything seems to be working fine, but it makes me nervous!  

Has Microsoft streamlined its file formats to make them even smaller in this new version of Office, or is something else going on here?

Good day

I am trying to colour blocks in PowerPoint based on the colour of cells in Excel. Essentially what I am doing is using a table in Excel and updating these values (not too regularly). Based on the cell value in Excel, I would like the block in PowerPoint to be a certain colour.

My initial thought was to use a conditional formatting method to change the cell colour in Excel, and then copy that same colour (using RGB numbers) to PowerPoint using a macro.

Would this be possible? I have not yet got around to trying to write the macro as I thought I may find a skeleton upon which to develop my solution.

Thanks in advance!

hi, How can you set the office templates to be the default when you open powerpoint instead of Featured? Also, how can you remove featured templates completely from the list? apart from the blank template?

Dear Experts,

I have a user which started to have an issue with opening ppt files this week over vpn.
The strange thing is it's only happening with ppt files, pptx are opening fine.
If I copy the ppt file from the Shared drive to the desktop it takes 3-4 Seconds to copy and around 10 seconds to open.
If I open the same ppt file directly from a network share it takes around 3-4 Minutes to open or Powerpoint is even crashing.
The same files are opening fast when on the Office network.
I'm running out of ideas what could be the issue.
I tried the following until now:

- repair office
- Adjust MTU of the Wifi adapter
- start Powerpoint in safe mode
- disable all Add-ins
- Add network share in the trust center to trusted locations (including subfolders)

It's still the same after all this.

the following is used:
- Windows 7 64 Bit
- Office 2013
- Cisco Anyconnect

Best Regards and many thanks in advance for any input,

Want Experts Exchange at your fingertips?
Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

I currently have a table in PowerPoint and in my column named "Answers" i can either have "True" or "False"

I would like the cell to change to one colour when it's "True" and another if "False"

Can anyone help me out with code?

Thank you :)
I am trying to get the attached “Section Exclusion Manager” to work for Powerpoint. The idea is to open a Powerpoint file that contains sections, save a user-defined copy of that file, display the section names and starting page numbers of the copy in the first picklist, move selected sections from that picklist to the second picklist, and then delete those sections from the file.

I have the code working for saving a copy in the same directory as the source and reading the section data into an array, but cannot get the first picklist to read and display that array (in Sub PopulateSourceList). Since I can’t do that, I can’t get the user selections to display in the second picklist, nor to then delete the sections from the copy. Have some code attempts to display sections in the picklist but they're not working. Can someone help with these three functions?

 Userform, code and sample source file (with sections) are attached as ‘Section Exclusion Manager PowerPoint (Test July 6 2017)’ and ‘PowerPoint Section Test’.
I am the pastor of a church which uses PowerPoint to display verses, graphics, and notes during my message.

We have several "volunteers" that create the PowerPoint each week.

What is happening is that some folks add automatic slide advancement animations on individual slides...
Groups of slides... text boxes or even inserted graphics.

With songs, the average slideshow is 90 slides.

Is there any was to automatically remove all automatic "Next Slide" animations?

Transitions are fine. (Fade in / out... etc...
When I have a PowerPoint file open... using two screens
And hit F5 so the Show runs...
I see a "timer" running in top left of screen?
Is that a countdown to the slide changing?
Or a count of how long it HAS been running.

I do NOT want it to change automatically.  This is manual click only

In the foyer I have a directory board which lists Clients Names and office Number. The slide show shows advertising material then the directory.

How can I repeat the Directory listing without having to copy it in between each advertising slide?

Looking for a Master slide (ie the directory listing) and some kind of place holder between each advertising slide.

Looking for a simple specific solution from someone who knows how to do it NOT vague suggestions.
how to modify the excel file of PPT's chart data  via PPT macro which takes input of a ID from a button on PPT slide and arrange data accordingly. Lets say I have a chart on slide 2, I want to automate that chart. I want a command button, which on click asks the customer ID for which we want to see the chart. and after entering the ID, the data excel file of chart automatically changes the data. I wrote a code in chart data excel file VBA which changes data according to the ID, but I am unable to get the input from PPT file and make that excel file run the code. Basically I am unable to connect the PPT VBA to that chart data excel file or it's chart data excel's VBA
I'm unable to play ANY audio files in PowerPoint 2016. If I play these outside of PowerPoint using Windows Media Player, QuickTime or DivX, they all work fine. I can insert a movie into a slide and it'll play fine but no sound. Insert a WAV or MP3 and it looks like it's playing OK but just no sound. I insert a link to an external YouTube clip and that did play the movie with sound OK. To eliminate a corrupt PowerPoint file, I've created a brand-new file with the same results. I've tested a file that doesn’t work within PowerPoint in PowerPoint Viewer and that plays the sound OK so I then ran a repair of the MS Office which didn’t fix the problem. Knowing that it must be a PowerPoint issue, I then completely uninstalled Office before re-installing but still the same problem. I've now completely run out of ideas. With previous versions of PowerPoint I could resolve this kind of issue by installing a Codec pack but I'm at a loss with this version. Help most welcomed.
Is there a way to extract data from a List in SharePoint 2013 directly into PowerPoint?
Hi Experts,
Could you pls advise, Is there a way to create animated flow chart. Basically trying create flowchart with animation on button click.

I know Microsoft PowerPoint and prezi has some capabilities but trying to get some advise if there is a better way to do it. :)

License product is also fine. we can look those options as well. :)

Thanks in advance
Enroll in July's Course of the Month
Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Having read this I was surprised and disappointed that there is no track changes feature in Powerpoint like there is in Word and Excel.  What is the reason for this illogical decision when they have it in other Office software?
I am trying to build a userform that enables one to select a Powerpoint file, display its section numbers in a listbox, and allow one to selected sections to remove from that listbox (which would then go to a second listbox) and have the macro delete those sections from the copy. I've attached code that copies a Powerpoint file with all of its slides but the code does not copy the sections. So I thought a two-dimensional array that captures the section names and first slides would suffice, so that I could use that array to create the same section names and first slides in the copy --  assuming that I could figure out how to get the firstslide number(s) from the user selections and then delete those sections from the copy. But I cannot figure out how to build this array. I can loop through the sections and get their names and firstslides, but not how to populate the array with that data and then use it to delete whichever sections are chosen from the second listbox. Can someone help get me started?
I'd like to convert a 2010 PPT presentation into 2013.  The size is wider on 2013 and this is what I'm interested in accommodating
What are some quick, easy ways of taking a 2010 PPT file and doing this..
I had this question after viewing VBA to change source of links in PowerPoint.

I tried this code in PowerPoint 2013 but it doesn't seem to word there, any suggestion of how can we link all the links to a different Excel file or folder?
In most of the Word and PowerPoint toolbars I develop using VBA, I use an Excel file to hold various kinds of data, which I read in using ADODB.  I've used this method successfully for years.

I just updated a PowerPoint tool for one client, and now one person out of a team of four is experiencing an error message in the middle of that ADODB loading sequence.  The weird thing is that only this one person is seeing the error.  It works fine for me and for the other 3 people on his team.  They are all running Office 2013.  I know it is successfully creating the connection to the Excel file, and have verified that it correctly reads the data from the first worksheet and loads it into the first public variable, but when it tries to move on to the next worksheet, it claims it can't find that sheet.  But the sheet is definitely there.  And again it works for everyone else.

Sub loadfromexcelw()

Dim Datafile As String
Dim objConnection As ADODB.Connection
Dim objRecSet As ADODB.Recordset
Dim x As Integer, y As Integer
Dim reccount As Integer, colcount As Integer, R As Integer, C As Integer
Datafile = contentlibraryfolder & "\ToolbarData.xlsm"

Set objConnection = New ADODB.Connection
objConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Datafile & ";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"";"  
Set objRecSet = New ADODB.Recordset
objRecSet.ActiveConnection = objConnection

Open in new window

This is weird.

I just opened a narrated project I successfully completed a few months ago and when starting the slide show on a specific slide, the audio narration is silent. All audio narrations (recorded in a studio and output to MP3 format) are set to be hidden during the slide show so I unhid one and looked to see what was happening during the slide show:
PowerPoint Cannot Play MediaNow the even weirder thing is that these audio files play perfectly fine when in edit mode (out of slide show mode) and, they play ok when starting the slide show on a different slide and then transitioning to the slide in question (checked with several narrated slides). The audio will not play when using Shift+F5 to start the slide show on a specific narrated slide. Or, I can use Shift+F5 to start on a specific slide, go back one slide then forward one slide and the audio then plays.

The animation pane is set to play each of the narration audio file automatically, After Previous, without a delay and are the first effect in the animation sequence.

After more testing, I found that the audio did play sometimes but mostly did not so it's even intermittent! What is going on?

PowerPoint 2016 (PC) 32 bit, Account Version : 1704 Build 8067.2115 Click-to-Run, About Version : 16.0.8067.2115

Microsoft PowerPoint

PowerPoint is a slide show presentation program currently developed by Microsoft. PowerPoint presentations consist of a number of individual pages or "slides" that may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. Slides can also form the basis of webcasts.