Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    726
    Thanks
    58
    Thanked 1 Time in 1 Post

    How do I see what fonts are used *where* in a PowerPoint presentation?

    Hi guys -

    On the Home tab, in the Editing section, Replace/Replace Fonts tells me that my deck contains several fonts I don't recall using -- and which I can't easily find within this massive file.

    Is there a way to identify what fonts are used where?

    I'm using PowerPoint 2016 on a PC.

    Thanks a lot!
    Last edited by Jon5; 2017-04-10 at 17:17. Reason: Clarity

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,897
    Thanks
    4
    Thanked 279 Times in 256 Posts
    You would probably need to create a macro to cycle through every text frame and query the fonts.

    However it may be easier to use that dialog to change the fonts to a wingdings type font not used anywhere else and then quickly eyeball the pages to try to spot anything out of the ordinary.
    If you can't see anywhere that the fonts have been used, they could easily be hiding on one of the slide masters so don't forget to look for them there.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    Jon5 (2017-04-16)

  4. #3
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    726
    Thanks
    58
    Thanked 1 Time in 1 Post
    Thanks so much, Andrew.

    Unfortunately, most of my presentations are so big and complex that eyeballing them isn't practical. Plus, I usually use only a handful of fonts, so the ones listed are likely hidden in very small text boxes or the notes section.

    Any idea how to create that macro?

    Thanks again.

  5. #4
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,897
    Thanks
    4
    Thanked 279 Times in 256 Posts
    Without seeing your presentations I can't guarantee that this will work but I would start with a macro like this which lists the fonts used on a shape by shape basis and reports it to the Immediate Window.

    I would assume that textrange.font.name would return a value only if everything in that range has the same font. If there is a textrange with a mixture of font names, this would return a blank which would become visible in the output as either a line commencing with a comma or consecutive commas.

    Code:
    Sub CheckFonts()
      Dim aTF As TextFrame, aShape As Shape, aSlide As Slide, oLayout As CustomLayout
      Dim sFontsOnSlide As String
      
      For Each aSlide In ActivePresentation.Slides
        sFontsOnSlide = ""
        For Each aShape In aSlide.Shapes
          If aShape.TextFrame.HasText Then
            sFontsOnSlide = sFontsOnSlide & aShape.TextFrame.TextRange.Font.Name & ", "
          End If
        Next aShape
        Debug.Print "Slide: " & aSlide.SlideNumber, sFontsOnSlide
      Next aSlide
      
      For Each oLayout In ActivePresentation.SlideMaster.CustomLayouts
        sFontsOnSlide = ""
        For Each aShape In oLayout.Shapes
          If aShape.TextFrame.HasText Then
            sFontsOnSlide = sFontsOnSlide & aShape.TextFrame.TextRange.Font.Name & ", "
          End If
        Next aShape
        Debug.Print "Layout: " & oLayout.Name, sFontsOnSlide
      Next oLayout
    End Sub
    The following sample output shows anomalies on Slide 1 and Slide 3 which show mixed typefaces in a shape
    Slide: 1 , Segoe UI Light,
    Slide: 2 Segoe UI Light, Segoe UI,
    Slide: 3 Segoe UI Light, Segoe UI, ,
    Slide: 4 Segoe UI Light, Segoe UI,
    Last edited by Andrew Lockton; 2017-04-17 at 02:40.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  6. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    Jon5 (2017-04-18)

  7. #5
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    726
    Thanks
    58
    Thanked 1 Time in 1 Post
    Thanks so much, Andrew!

    I seem to be doing something wrong, though, because after I run the macro, nothing happens...

    Any idea what I'm doing wrong?

    Thanks again!

  8. #6
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,897
    Thanks
    4
    Thanked 279 Times in 256 Posts
    I thought it might be a bit subtle

    The output is being directed to the Immediate Window which is a window in the VBA editor. If you can't see it in the VBA Editor press Ctrl-G or find it under the View menu.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  9. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    Jon5 (2017-04-19)

  10. #7
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    726
    Thanks
    58
    Thanked 1 Time in 1 Post
    Aha! So I run the macro, then open the macro, then in the VBA editor, go to View/Immediate Window. Got it -- thanks!

    There's just one thing: Replace/Replace Fonts tells me I'm using several fonts that don't show up in the Immediate Window. Here a couple of screen shots.

    Untitled.png

    untitled 2.png

    Any thoughts? Thanks again!

  11. #8
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,897
    Thanks
    4
    Thanked 279 Times in 256 Posts
    I assume you scrolled in the window to see the complete output.

    Another place that rogue content could be hiding is in the Notes pages. Have you looked in there?

    I don't have time to test at the moment but grouped shapes may also avoid my macro's output but be picked up by the Replace Font dialog. Your slides look like they usually only contain one text frame so that looks somewhat suspicious.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  12. #9
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    726
    Thanks
    58
    Thanked 1 Time in 1 Post
    Hi there -

    Yep, not in the Immediate Window.

    Don't think so, since I exported the slides as handouts, and didn't see rogue fonts in the Notes section.

    Here's the deck I'm "testing" this macro on -- it's rather short.

    Any ideas?

    Thanks a lot.
    Attached Files Attached Files

  13. #10
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,897
    Thanks
    4
    Thanked 279 Times in 256 Posts
    In that file go to View > Outline View. In the Notes area down below the slides you have a mix of fonts. Slide 1 is empty but using Calibri, Slide 2 has content using Times New Roman etc.

    Also, go to View > Handout Master and explore the multiple text boxes there.
    And go to View > Notes Master. More text boxes there plus a selectable dummy slide that has a fontname associated with it.

    I guess you could modify the macro I provided to also examine these components of the file but its just simpler to make use of the dialog that caused you to ask the question in the first place.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  14. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    Jon5 (2017-04-20)

  15. #11
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    726
    Thanks
    58
    Thanked 1 Time in 1 Post
    Many thanks, Andrew.

    Good catch on slide #1 -- fixed!

    I deleted all the stuff I saw in Handout Master and Notes Master, yet I still can't ascertain where Gotham, Arial, or any remaining instances of Calibri are hiding.

    Any other thoughts?

    Here's the latest file.

    Thanks so much for your patience and expertise.
    Attached Files Attached Files

  16. #12
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,897
    Thanks
    4
    Thanked 279 Times in 256 Posts
    To see Arial in there, go to View > Slide Master. Click in the body text box which has the 5 levels of bulleted text. Click on the second level element and go to Home > Bullets > Bullets and Numbering > Customize

    So the fonts can be hiding as bullet characters on masters. I didn't see Gotham there but it could be hiding in similar places.

    If it really means that much to you to find where these fonts have been used, open the pptx file with a zip tool or change its file extension to .zip and double click it. Inside you will find lots of xml files nested in a logical folder structure. Extract copies of all of them to a folder and use Notepad or some other text file reader to open each one and search for the font name in question. When you find it, look at the tags around it and see if that gives you a hint where you can go to find the instance via the Powerpoint GUI. I found 9 instances of Arial in slideMaster1.xml

    You could conceivably edit the xml files to change these fonts and replace them in the pptx file. This may or may not be successful but it certainly won't be as easy as using the Replace Fonts dialog.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  17. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    Jon5 (2017-04-21)

  18. #13
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    726
    Thanks
    58
    Thanked 1 Time in 1 Post
    Thanks, Andrew.

    1. I deleted all the master slides, yet Arial, Gotham, and Calibri still remain -- somewhere...

    2. I renamed the PPT as a ZIP, and searched all the XML files, yet I couldn't find any instances of the word "Gotham" (I didn't search for Arial or Calibri.)

    At this point, I'm totally stumped.

    Surely it shouldn't be this difficult to find a font within 24 slides, each of which has but a few words on it?

    (This isn't in any way criticism of you; you've gone above and beyond!)

    Thanks again.

  19. #14
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,897
    Thanks
    4
    Thanked 279 Times in 256 Posts
    This is quite an academic exercise now. Open your presentation, go to Slide 2. Press Ctrl-A and change the spell check language to Persian by clicking on the language down in the status bar. Suddenly the font says 'Gotham'.

    I found this by:
    1. Check all the fonts in the replace fonts dialog - Gotham listed
    2. Delete all slides and check again - no Gotham - therefore must be on at least one slide
    3. Reinstate original slides and delete half the slides - still Gotham
    4. Delete all slides except Slide 1 - No Gotham. Check when only Slides 1 and 2 - Gotham - Hence Gotham must be somewhere in Slide 2
    5. Now open zip version and examine Slide2.xml and find the font in a tag called a:cs which looks to be related to the a:latin where the DIN font appears.
    6. Do a google search to find out what cs and latin means and find info including
    http://www.brandwares.com/bestpracti...emes-complete/
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  20. The Following User Says Thank You to Andrew Lockton For This Useful Post:

    Jon5 (2017-04-22)

  21. #15
    5 Star Lounger
    Join Date
    Jun 2001
    Location
    USA
    Posts
    726
    Thanks
    58
    Thanked 1 Time in 1 Post
    Thanks so much for sticking with me on this, Andrew.

    I don't have Persian, but I have Spanish -- see attached -- though I wasn't able to see where "Suddenly the font says 'Gotham'"...

    Nonetheless, I actually deleted slides 1-3, and yet "Gotham" still remains under Replace Fonts; see attached.

    What am I missing?

    Thanks again.
    Attached Images Attached Images
    Attached Files Attached Files

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •