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...

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 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
     …

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!

Laevashan

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,

Patrick

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 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...

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.

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.

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

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'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..

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"";"  
 
objConnection.Open
Set objRecSet = New ADODB.Recordset
objRecSet.ActiveConnection = objConnection
 

Select all Open in new window

…