PDA

View Full Version : Sleeper: Select all shapes on a slide that have no fill



Oriya
03-18-2021, 03:27 AM
I'm after some VBA for PPT that selects all the shapes on a slide that have no fill (sorry I can't edit the title). Can anyone help please?

John Wilson
03-18-2021, 05:00 AM
Try this

NOTE as written it will ignore placeholders which normally have no fill


Sub selector()
Dim osld As Slide
Dim oshp As Shape
Set osld = ActiveWindow.Selection.SlideRange(1)
ActiveWindow.Selection.Unselect
For Each oshp In osld.Shapes
If oshp.Type <> msoPlaceholder Then
If oshp.Fill.Visible = False Then oshp.Select Replace:=False
End If
Next oshp
End Sub