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.
No comments:
Post a Comment