move worksheet to another workbook, without the vba code but keeping the colour scheme

[knuto01]

I current have some code that first copy a worksheet do some cleaning and then move it to another workbook.
My problem is that when i copy or move a sheet it also copies the vba code that is attached to the sheet object.
Is there a way to avoid this?
Also when i move the sheet to another workbook the colours changes. Is there a move option that allows to keep the source formatting, much like the paste in the excel ribbon.
Currently I'm exporting the colour scheme and then importing it to the new workbook, but that requires unlocking the source workbook and with the new (2013) security it takes a very long time.
Ideas are highly appreciated.

 

[Andrew Poulsom]

Welcome to MrExcel.

Have you tried copying the cells to a new worksheet rather than copying the worksheet?

 

[knuto01]

That is how i'm doing it now. But what i really want is to move it to another workbook, without the vba code but keeping the colourscheme.

 

[Andrew Poulsom]

If you copy the cells to a new worksheet (not copy the worksheet) the VBA code won't be copied.

 

[DILIPandey]

I guess a) copy - paste special - values and b) copy - paste special - formats, should work.


Regards,
DILIPandey

 

[knuto01]

I have now fixed the VBA code issue by copying the cells instead of the sheet. But the colour issue remains.

 

[knuto01]

When I add a new workbook, that workbook is using whatever default colour scheme that pc has set up. When i then move the sheet to that workbook it will use the new colour scheme, so that if a cell is using f.eks. the 12th colour in the scheme it may be a different colour. Is there a way to copy the colour scheme or to keep the sheets colour scheme when moving. and without having to unlock all sheet in the source workbook.