Copying worksheet while keeping row heights of merged cells and active X controls

Hello,

I have a macro that ask the user to input a value and then the macro will create a new worksheet by copying a hidden template worksheet and then name that new worksheet as the value entered by the user. All is working fine. My problem is that the new created worksheet (based on the template worksheet) is not exactly formatted the same as the template worksheet. The row heights is not the same as the template worksheet and the active x controls (checkboxes) that were on the template worksheet are not copied. My template worksheet does used merged cells (I know I am not supposed to but I had to because on my client request).

So my question is how can I copy the template worksheet while keeping the row heights as well as the active X controls ? Please see the codes below. I highlighted in bold where I have trouble.

Please Login or Register  to view this content.

If this may help, I am using another macro that saves a worksheet as a workbook. The code in that macro does exactly what I want (copies the row heights of merged cells as well as the active x controls) but I was not able to merge it with the macro above.

Please Login or Register  to view this content.

Thank you for all your help

Originally Posted by buran

Don't copy the cells, copy the template worksheet instead and it will keep the formatting

Thank you buran, makes alot of sense! I should have thought about but I was trying to resolve it with the orignal code (which should have copied the worksheet as well in their code). I will mark as solved. Thanks again!

Originally Posted by buran

You may want to check the code in my second post - make sure the user input is a valid sheet name

Ok thanks I will review your code, thank you for your time.