View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Christopher King[_2_] Christopher King[_2_] is offline
external usenet poster
 
Posts: 6
Default XL2007 Bug: ControlFormat in "For each"

Here's a workaround: just change the For each... Next to For... Next. The
following works:

Sub Play7()
Dim shpS As Shape
Dim N As Integer
For N = 1 To Selection.ShapeRange.Count
Set shpS = Selection.ShapeRange(N)
With shpS
Debug.Print shpS.Name
Debug.Print shpS.ControlFormat.LockedText
End With
Next N
End Sub


This solution to the problem seems general, so this bug doesn't seem so
critical as I originally thought.