I don't know an easy way to merge all the workbooks without doing some VBA
work. But you can print all the sheets in a workbook by highlighting the
first sheet tab, hold down CTRL, then click the last sheet tab. Then Print.
Each sheet will start a new page and use it's own page setup.

Let us know how you do.

"schunker" wrote:


i have project which consist of ten workbooks each contaning 12 worksheets.
i would like to link them all togother, for seaching purposes. i would also
like to print each workbook as book ie each worksheet on differrent page. can
this be enbloc or will i have to print each sheet separetly
cheers