26 Sheets (or tabs) in the Workbook, if you print each sheet it would print
out several pages for each sheet. There are 8 sheets that I want to print
out only the first page then combine into a report. Currenlty I have the
option of clicking on each sheet one at a time and printing the first page
only. This is time consuming becuase it takes a few minutes to calculate the
workbook before it prints. The other option I have is to right click on each
sheet or tab and print this only calculates once but then prints extra pages
that I don't want since it prints all the pages in each sheet.

Ben

"harpscardiff" wrote:


I obviously misunderstood, sorry

how many sheets in your workbook?
It s just one workbook?
What do you mean first page? Surley thats just the first tab?

More info please???


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=489409