View Single Post
  #1  
Old 18-06-2012, 08:39
noj noj is offline
Member
 
Join Date: Oct 2011
Location: Sydney
Posts: 31
Default Code to determine if shape is powerclip

I'm going nuts! Can someone please tell me the simplest way to determine if a selected shape is a powerclip or not with VBA code? Based on a thread I found in this forum that Shelby answered, I tried this method:
Code:
Private Sub GlobalMacroStorage_SelectionChange()
     Dim s As Shape
     Set s = ActiveSelection
     If s.PowerClip Is Nothing Then
          UserForm1.CheckBox1.Visible = False
     Else
          UserForm1.CheckBox1.Visible = True
     End If
End Sub
... but it's not working. Am I missing something?

Last edited by noj; 18-06-2012 at 08:53.
Reply With Quote