Change Print setup when worksheet is selected

I have some code that this Forum has help me build and now I have a need to change it.
as the code states it will run when a “print” Commend or “Print Preview” Command is activated.

When I wrote this code I was using Excel 2003, now I have been upgraded to Excel 2010
Now the print Preview is different and the record macro does not give me any code.

What I would like to do is change it so that when a worksheet is selected, then the "page setup" is updated for that worksheet only.
This code was placed in the "workbook", to do what I need to do now, I believe what I would have to do is put it either in each worksheet or put a call into each worksheet

Here is my code

Please Login or Register  to view this content.

Note:
What is important to me is CenterHeader, this get info that the user has enter on the main worksheet and is need on print out for other worksheet only when printed, theses worksheets are also linked to other programs

Hello CityMPLSEmpolyee ,

The code you have will work in Excel 2010. The properties and events for the Workbook and Worksheet objects from 2003 work in Excel 2010. What problems are experiencing with the code?