list shapes’ macro assignments

Public Sub list_shapes_properties()
    Dim ws As Worksheet
    Dim s As Shape
    
    For Each ws In Worksheets
        For Each s In ws.Shapes
            Debug.Print ws.Name, s.Type, s.Name, s.OnAction
        Next
    Next
End Sub

http://www.pptfaq.com/FAQ00008_Show_the_-Type_of_each_shape_-including_shapes_in_groups-.htm
http://msdn.microsoft.com/en-us/library/office/aa174301(v=office.11).aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s