code to move images

  • Thread starter Thread starter xavi garriga
  • Start date Start date
X

xavi garriga

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!
 
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
 
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"
 
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;
 
Back
Top