Copy page format into an entire workbook

For proper printing I need to copy the format from one tab into all of the
other tabs in a work book. I have 35 files with up to 40 tabs in each file.
Is there a way to copy the format once for each Excel file

Since the term "format" is rather generic I can only supply a generic method.

Select first worksheet tab then right-click and "select all sheets".

Do your formatting on active sheet and it will be done to all sheets.

DO NOT FORGET to ungroup the sheets when done.

NOTE: while in group mode, some Print Setup features are not
available........set print area, print titles to name two.

To do all sheets in all files would require VBA code to open each file,
operate on all sheets in the file, save/close and open next file.


Gord Dibben Excel MVP


On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
<mdeanda@discussions.microsoft.com> wrote:

>For proper printing I need to copy the format from one tab into all of the
>other tabs in a work book. I have 35 files with up to 40 tabs in each file.
>Is there a way to copy the format once for each Excel file

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>

Did you ever get your answer? I have the same problem and believe me the
right click (group) thing works but is real limited. You can not set print
area nor can you clear print area in a workbook. That has to happen on the
worksheets. I saw something in MS Help that had the name, define, option.
That only works on the worksheet you are defining the print criteria. If
anyone out there has a simple VBA or macro code that can be written it would
surely be great.

"Gord Dibben" wrote:

> Since the term "format" is rather generic I can only supply a generic method.
>
> Select first worksheet tab then right-click and "select all sheets".
>
> Do your formatting on active sheet and it will be done to all sheets.
>
> DO NOT FORGET to ungroup the sheets when done.
>
> NOTE: while in group mode, some Print Setup features are not
> available........set print area, print titles to name two.
>
> To do all sheets in all files would require VBA code to open each file,
> operate on all sheets in the file, save/close and open next file.
>
>
> Gord Dibben Excel MVP
>
>
> On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
> <mdeanda@discussions.microsoft.com> wrote:
>
> >For proper printing I need to copy the format from one tab into all of the
> >other tabs in a work book. I have 35 files with up to 40 tabs in each file.
> >Is there a way to copy the format once for each Excel file
>
>