Does sheet need to be visible to copy picture from it?

I placed a picture on a worksheet to use on other sheets in a macro, but the sheet is always hidden when I run the macro. I found I had to make it visible, copy the image, then hide it. Is this the case, or is there a better way of doing this? I could place it on one of the sheets which is always visible, but it is not at the start and if others are doing this, I want it done from my "welcome" worksheet. Maybe there is a way I can move the image to another sheet? I have a spot on the welcome sheet three rows wide and two high for this image to fit into. If a macro could be written to move this image to another sheet, then shade those 6 cells and remove the commandbutton would be icing on the cake! I could try recording my steps, but I have found that some steps do not seem to be recorded. Thanks, AGAIN!

Please Login or Register  to view this content.

if u don't use mothed "select", then visible is needn't
u can use copy directly, the code could be:
Sheets("Welcome").Shapes("Picture 1").Copy

Awesome, thanks simcode! I will give that a try.

Works! Or, as I also just found out, I could do this?

Sheets("Sheet15").Shapes("Picture 1").Copy

certainly, if "Picture 1" is there

I moved this line over and now get this error.
Macro_error.JPG

Originally Posted by davesexcel

Remember that time I suggested attaching a sample workbook?

Well you haven't yet, and it is hard to work with a workbook that we can't see.

I would if I could, but it's too big and complex to "make simple" and post. I posted the macro, that doesn't help?

If you can attach a workbook as sample, then maybe it is easier to understand and tackle your problems

I figured out some of the problem and from another question I posted on this forum was able to get the balance figured out, so all is good now and I will mark this as solved. Thanks to all for their help and yes, sometimes it's difficult to explain and an example would be easier, but sometimes that is more difficult than the problem itself.

I think you perhaps need something like this

Please Login or Register  to view this content.

Thanks