code to move images
 

Hi to all;

I've inserted some images in excel with the "desgn mode"; which code do I
have to write in a VB Macro, or property have to change in order to be able
to move these images without being in the "design mode"?

Thanks to all!
--
atrep

code to move images
 

for each shp in activesheet.shapes
shp.left = a
shp.top = b
shp.width = c
shp.height. = d

next shp
where a,b,c,d is in pixels


"xavi garriga" wrote:

Hi to all;

I've inserted some images in excel with the "desgn mode"; which code do I
have to write in a VB Macro, or property have to change in order to be able
to move these images without being in the "design mode"?

Thanks to all!
--
atrep

code to move images
 

Turn on the macro recorder and move them manually. Then turn off the macro
recorder. Then use that code as a model - modify it to do what you want.

That code should run without being in the "design mode"

--
Regards,
Tom Ogilvy


"xavi garriga" wrote:

Hi to all;

I've inserted some images in excel with the "desgn mode"; which code do I
have to write in a VB Macro, or property have to change in order to be able
to move these images without being in the "design mode"?

Thanks to all!
--
atrep

code to move images
 

Hi to all!

Thanks for the responses, I've tried them, and workperfectly, but they are
not exacly what I want, maybe I should explain me better(sorry, my English
can be much better :P)

I have a CommandButton that makes appear and disappear some images depending
on some conditions, what I want to do is to move the images that are visible;
I want to treat with this images like a normal pictures, this should be able
to resize, move, copy, paste...all of it wothout being in the "design
Mode"(if it is posible)

I hope this explanation is better than the previous one;

Thanks to all and kind regards;