Macro to re-design the same worksheet than the one open.

[jbesclapez]

Hello,

I have kind of a silly question.

Imagine you have a workbook.
I would like to have a VB that would recreate the exact same workbook.
Note that it is not a simple copy paste. The VB will write all cells, add buttons if they are some, add the VB if tehre is any... a bit like a human would do manually..

Thanks

 

[offthelip]

It is not as simple as that because the cell format is a complicated object with lots of properties , have a look at this link:
CellFormat object (Excel)