Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-24-2016, 12:17 AM
JohnWilson JohnWilson is offline Powerpoint VBA to remove/replace/delete certain colored font in textbox and in tables Windows 7 64bit Powerpoint VBA to remove/replace/delete certain colored font in textbox and in tables Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,914
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

This would help but if you have equations they follow different rules and you may get unexpected results

Code:
Sub delblue()
   Dim oSld As Slide
   Dim oShp As Shape
   Dim x As Long
   Dim l As Long
   Dim i As Long
   Dim j As Long
   Dim otr As TextRange
   Dim otrTotal As TextRange

   For Each oSld In ActivePresentation.Slides
      For Each oShp In oSld.Shapes
         If oShp.HasTextFrame Then
            If oShp.TextFrame.HasText Then
               With oShp.TextFrame.TextRange
                  For x = .Runs.Count To 1 Step -1
                     If .Runs(x).Font.Color.RGB = RGB(0, 0, 255) Then
                        Set otr = .Runs(x)
                        For l = 1 To otr.Length
                            If otr.Characters(l).Font.Color.RGB = RGB(0, 0, 255) Then otr.Characters(l) = "_"
                           If otr.Characters(l) = "_" Then otr.Characters(l).Font.Color.RGB = RGB(120, 120, 120)
                        Next l
                        .Runs(x).Font.Subscript = msoFalse
                        .Runs(x).Font.Superscript = msoFalse
                     End If
                  Next x
               End With
            End If      'has text
         End If      'has textframe
         If oShp.HasTable Then
            For i = 1 To oShp.Table.Rows.Count
               For j = 1 To oShp.Table.Columns.Count
                  If oShp.Table.Cell(i, j).Shape.TextFrame.HasText Then
                  Set otrTotal = oShp.Table.Cell(i, j).Shape.TextFrame.TextRange
                     With otrTotal
                        For x = .Runs.Count To 1 Step -1
                           If .Runs(x).Font.Color.RGB = RGB(0, 0, 255) Then
                              Set otr = .Runs(x)
                              For l = 1 To otr.Length
                              If otrTotal.Paragraphs.Count > 1 Then
                              If Asc(otr.Characters(l)) = 13 Then
                              otr.Characters(l) = vbCrLf
                               Else
                                otr.Characters(l) = "_"
                                 If otr.Characters(l) = "_" Then otr.Characters(l).Font.Color.RGB = RGB(120, 120, 120)
                               End If
                               Else
                                If otr.Characters(l).Font.Color.RGB = RGB(0, 0, 255) Then otr.Characters(l) = "_"
                                 If otr.Characters(l) = "_" Then otr.Characters(l).Font.Color.RGB = RGB(120, 120, 120)
                               End If
                              Next l
                              .Runs(x).Font.Subscript = msoFalse
                              .Runs(x).Font.Superscript = msoFalse
                           End If
                        Next x
                     End With
                    End If
                  Next j
               Next i
            End If
         Next oShp
      Next oSld
   End Sub
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
 

Tags
powerpointvba, pptvba, replacefont



Similar Threads
Thread Thread Starter Forum Replies Last Post
Powerpoint VBA to remove/replace/delete certain colored font in textbox and in tables Does anyone know how to remove breaks between tables? chrisd2000 Word Tables 18 07-02-2014 02:48 PM
Powerpoint VBA to remove/replace/delete certain colored font in textbox and in tables Codes for Word Textbox Font Color? tinfanide Word VBA 7 10-23-2012 03:13 PM
changing default font for new textbox? dylansmith PowerPoint 3 10-18-2012 11:12 AM
PowerPoint 2007 Textbox Lock / Form Issues LTechie12 PowerPoint 0 01-08-2012 02:08 PM
Printing in white data in a colored PowerPoint 2007 Chart bigbizz PowerPoint 0 08-29-2011 07:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft