Copy sheets....and page setup

[GustavBA]

Hi all



I have a problem I hope you can help me with. I have fond some code helping me with copying all the sheets from one workbook into a new one. I am only copying values though. This is done because the workbook should be distributed and i dont want all my formolas in it.



Now I would very much like the page setup for each sheet including header, footer etc. to be copied to the new workbook. Is that possible?

One more thing. I would also like the sheets in the new workbook to have the same name as in the original workbook.



Here is my code until now:

Please Login or Register  to view this content.

[royUK]

GustavBA

You must use Code Tags when posting code to the Forum. This is explained in the Forum Rules - see links below.

I will add them this time, if you click the Edit button on question you will see how to do it.

[royUK]

Just create a copy of the workbook & remove all formulas

Please Login or Register  to view this content.