Right click on any sheet tab, select SELECT ALL SHEETS, then set your print
ranges as you normally would. All visible worksheets will be printed with
the same print range.
--
Kevin Backmann


"Simon Willard" wrote:

without having to set up for each worksheet individually?