Excel can not copy the objects to another sheet

[goody2006]

Hi,
I have been following the forum for a while. Whicever question I had, I could find so far except this one. Here it is : I have a big macro that runs in everyone's PC except mine. Once I debug it, it shows that it stocked at copying the objects from a template sheet to another sheet. When I try doing it manually, I still can not copy the objects to another sheet. It copies the sheet but except the objects in it. Is it related to my settings? Your help is much appreciated.
Thanks

 

[sky1in5]

you might need to use paste special instead of normal paste as your cell may contain formula..

 

[RoyR]

Under the objects properties is "Don't move or size with cells" selected?

 

[goody2006]

Under the objects properties is "Don't move or size with cells" selected?

Hi,
Thanks for the respond. Where is that selection made? Thank you.
I am trying to create a copy by right clicking on the sheet name and selecting Move or Copy. That is where I am having problem. It doesn't let me to select paste special there.

Thanks for your responds, really appreciated.

 

[RoyR]

I use that method often and everything is moved or copied over. Another method to copy the entire sheet is to right click on the small square above row 1 and left of the letter A. It will select the entire worksheet. You can then paste with pastespecial if you wish. Click the same spot on the worksheet you want to make the copy too. In reguards to the object properties, you did not say what type of object you want to copy over but for autoshapes for example, rightclick on the autoshape and choose Format Autoshape. Then click the properties tab. I am sure it would be similar with all objects although I have never tried it with every type of object. If "Don't move or size with cells" is selected then the object will not copy over.

 

[goody2006]

Hi,
I can manipulate the properties when I click on the objects but the problem is that the macro stops working when it tries to copy the sheets. There should be a setting that I turn off all locks to object copying. This macro only stops working on my PC. Is there any way to change this setting without right clicking the object?
thanks

 

[RoyR]

Can you post a copy of the macro?