I have an excel template and on one of the sheets, there is a button that copies the sheet and pastes it after the current sheet.

When i click on the new sheet, i can see that none of the objects have been copied over, like rectangles and buttons. All the cell formatting and validation is copied over ok.

The template was created in Excel 2002 and i am trying to use it on a laptop with Excel 2010. There is another computer in the office that has Excel 2010 and the problem doesn't exist on that computer. I have gone through the options on the laptop and set them to be exactly the same as the computer but the problem still exists.

If i right click on the sheet tab and copy the sheet that way, it still doesn't work.

Can anyone assist?

Thanks