Disable command button to be copied

[ShieBoon]

Hi all, i have a range in a worksheet which i want to copy to another worksheet when i click on a command button, in the same worksheet. Unfortunately, the command button lies within the range. Thus whenever i click the button, the button gets copied over too. How can i prevent the button from being copied over in vba?

I've tried recording macro while copying over with paste special, xlFormats, xlValues.

If i do it manually in excel, the button doesn't gets copied over. However using the same codes recorded by the macro recorder, the button still gets copied over. Any ideas?

Thanks
excel 2003
Shie Boon

 

[repairman615]

Hello,

One solution may be to right click the command button and select Format Control. Under the Properties tab check "Don't move or size with cells".

Does that Help?

Jeff

 

[Sektor]

1. Right-click on button
2. Format Control...
3. Properties
4. Don't move or size with cells

 

[ShieBoon]

yes it does! thank you guys! How did you guys know about this? I didn't manage to find it tru google :/