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