I'm trying to copy a worksheet from one workbook to another Workbook. On the worksheet that needs to be copied, it has an Oval drawing object. The background colour of the Oval is white. The Workbook that I'm copying to is an .xlsm file.
If I use Workbook.Copy it works fine, the background property has been preserved. If I use Worksheet.Copy, the Oval shape's background property is not preserved.
Why is this? Should the Copy functionality between the two Workbook and Worksheet objects be the same?
I need to use Worksheet.Copy because I need to preserve a macro in a worksheet that I have in the .xlsm that I'm copying to. Workbook.Copy will overwrite this Worksheet with the macro.
I tried using Workbook.Combine, but it does not preserve the macro either.