Format all pictures
Assuming there are no other objects on the worksheet that would be
considered pictures, you can do
Sub ABC()
With ActiveSheet
.Pictures.Width = 30
.Pictures.Height = 45
End With
End Sub
You will have to consider whether the aspect ratio is locked and so forth.
To test what is in the pictures collect
Sub EFG()
activesheet.pictures.select
End Sub
--
Regards,
Tom Ogilvy
"David Henderson" wrote in message
...
Please can someone tell me if it is possible to reference all pictures on
a
worksheet from a macro, without having to manualy select each one
individualy beforehand, so that I can simply change the size of them all.
For instance can they ocupy a range?
Thanks in advance
David
|