How to select one by one picture on my sheet with VBA?

M

marko

Hi!

How can i select one by one picture on my sheet through VBA
"for each pic in Activesheet.pictures...?
and how do i have to define(dim) my picture, dim pic as???
please help. thanks!

Marko Svaco
 
L

Leith Ross

Hello Marko,

A Picture belongs to the Shapes class of the Worksheet it is on.

Dim Pic As Shape
For Each Pic In Activesheet.Shapes
If Pic.Type = msoPicture Then
Pic.Select
End If
Next Pic

Sincerely,
Leith Ros
 
D

Dave Peterson

dim pic as picture

should work ok, too.

If you use the object browser (F2 in the VBE), you can show hidden elements and
still see the picture object.
 
Top