L
Lisa Wenzel
Hello everybody,
I have a group with lots of shapes and want to change the PInX and PinY of every one.
My code is: =
Public Sub changePIN()
Dim shp As Shape
If Application.ActiveWindow.Selection.Count =3D 1 Then
Set shp =3D Application.ActiveWindow.Selection.Item(1)
shp.CellsSRC(visSectionObject, visRowXFormOut, visXFormLocPinX).FormulaU =3D=
"Width*1"
shp.CellsSRC(visSectionObject, visRowXFormOut, visXFormLocPinY).FormulaU =3D=
"Height*1" =
Else
MsgBox "Bitte w=C3=A4hlen Sie etwas aus"
End If
End Sub
The macor works, but I=C2=B4ve a problem using it for grouped shapes: When I select a s=
hape in a group, the macro says, that no shape is selected.
What do I have to do to fix that???
Thank you for your help,
regards
eLiz
url:http://www.ureader.com/gp/1133-1.aspx
I have a group with lots of shapes and want to change the PInX and PinY of every one.
My code is: =
Public Sub changePIN()
Dim shp As Shape
If Application.ActiveWindow.Selection.Count =3D 1 Then
Set shp =3D Application.ActiveWindow.Selection.Item(1)
shp.CellsSRC(visSectionObject, visRowXFormOut, visXFormLocPinX).FormulaU =3D=
"Width*1"
shp.CellsSRC(visSectionObject, visRowXFormOut, visXFormLocPinY).FormulaU =3D=
"Height*1" =
Else
MsgBox "Bitte w=C3=A4hlen Sie etwas aus"
End If
End Sub
The macor works, but I=C2=B4ve a problem using it for grouped shapes: When I select a s=
hape in a group, the macro says, that no shape is selected.
What do I have to do to fix that???
Thank you for your help,
regards
eLiz
url:http://www.ureader.com/gp/1133-1.aspx