I normally create workbooks with several worksheets. These worksheets
usually have identical formats, including what I want in the custom header
and footer. I am continuosly frustrated by not being able to select an
option that will automatically share the Page setup options across the
worksheets within the workbook. I am forced to go to each worksheet and
enter the custom information.