1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Sub InfoShapes()
Dim Sh As Shape
For Each Sh In ActiveSheet.Shapes
Arrow = Sh.Type = 9 And (Sh.Line.BeginArrowheadStyle > 1 Or _
Sh.Line.EndArrowheadStyle > 1)
Forme = Switch(Sh.Type = 8, "Bouton", Arrow, "Flèche", Sh.Type = 9, "Trait", _
Sh.Type = 13, "Image", Sh.Type = 17, "Zone Texte")
STyp$ = IIf(Forme > "", Forme, Sh.Type)
If Sh.ZOrderPosition Mod 8 = 1 Then
Debug.Print String(120, "")
Debug.Print "ZOrderP", "Name", "Type", " Left", " Top", _
" Height", " Width", "AlText", "OnAction"
End If
Debug.Print Chr(-(Not Sh.Visible) * 183) & " " & Sh.ZOrderPosition, _
Sh.Name, STyp$, Sh.Left, Sh.Top, Sh.Height, Sh.Width, _
Mid(Sh.AlternativeText, 1, 13), Sh.OnAction
Next Sh
End Sub |
Partager