Convert existing worksheet to VBA code in order recreate the the identical worksheet

[kkruze]

I have a workbook with worksheets that include hundreds of rows and dozens of columns, fully formatted with borders, colors, formulas etc. The sheet contains both static areas and areas where users input information. What I want to know is there a way to take a sheet and copy (for lack of a better term) the underlying code or to put it another way have a spreadsheet be converted in to code that would replicate that same sheet(S).

I am not asking how to copy and paste a work sheet via vba. Nor do I want to have to record macros as a recreate a sheet, or starting coding from scratch.

Rather want to have the actual code that would result in the exact sheet being recreated once the code is run. Much appreciated

 

[FDibbins]

Not sure that I understand what you talking about here?

If you want to replicate a sheet exactly,
right-click the tab name and select Move Or Copy
Check the Create Copy box
Select where you want the copied sheet to be (or select (to the end)
click OK

You will now have a carbon-copy of that sheet...rename if needed

 

[FDibbins]

x-posted here
Convert existing worksheet to VBA code in order recreate the the identical worksheet

 

[kkruze]

Not sure that I understand what you talking about here?

If you want to replicate a sheet exactly,
right-click the tab name and select Move Or Copy
Check the Create Copy box
Select where you want the copied sheet to be (or select (to the end)
click OK

You will now have a carbon-copy of that sheet...rename if needed

I would like vba code to create an identical sheet without having to copy the sheet and then paste the sheet. For example I want to distribute vba code that will create the sheet I have, the user would not have access to copy an existing sheet, rather they could simply run the macro. I realize I could write a module or several that could create the sheet as I have but I would rather have a process that could simply take the sheet and convert to code that would recreate the sheet, not copy and paste.

thanks

 

[skyggelys]

I would like vba code to create an identical sheet without having to copy the sheet and then paste the sheet. For example I want to distribute vba code that will create the sheet I have, the user would not have access to copy an existing sheet, rather they could simply run the macro. I realize I could write a module or several that could create the sheet as I have but I would rather have a process that could simply take the sheet and convert to code that would recreate the sheet, not copy and paste.

thanks

I'm looking for exact same, ever found answer for this?