See your first post for another response.


Gord Dibben MS Excel MVP

On Mon, 7 Jan 2008 09:08:00 -0800, G. Dagger
wrote:

Thanks Kevin, just one more thing however, when i add a new worksheet the
default parameters are still there. Is there anyway for a new worksheet to
reflect the changes automatically?

"Kevin B" wrote:

Select the sheets to format (click on the first sheet and shift click on the
last sheet to select contiguous worksheets, or click on the first sheet and
Control + Click to select non-contiguous sheets) to turn Group Mode on and
then add the formatting as needed as well as any common formulas. Formatting
and formulas are placed in all selected worksheets.

When finished right click on any selected worksheet tab and selet UNGROUP
SHEETS.


--
Kevin Backmann


"G. Dagger" wrote:

Hi, not sure if my 1st message posted ok, but in any case, my question
relates to what the best method would be to format each worksheet the same
(i.e. same page layout, orientation, header) in any given workbook that has
information already saved on it, and have the same formatting for when a new
worksheet is added. I have severak workbooks that require their own specific
editing, thus i need to avoid a mass default of specific parameters.

Thanks.