You can get all the worksheets in a single workbook by grouping them.

Click on the first worksheet tab and ctrl-click on subsequent.

File|page setup
change your stuff

And ungroup the sheets. Almost anything you do to a sheet in a group gets done
to the other sheets in that grouping--sometimes nice, but often disastrous.

nigelb wrote:

I am creating a "pad" of workbooks with individual name for each workbook.

I want to quickly insert the name as a custom header but have to go into
each individual sheet, is there a quicker way?

--

Dave Peterson