copy custom header from one worksheet to another in same workbook

[Guest]

Could you please let me know simply how to copy and paste the custom header
from one workshheet of a workbook on to one or two additional worksheets of
the same workbook which do not have that header

Thank you very much
Aamir

 

[Gord Dibben]

Select worksheet with custom header.

CTRL + Click on other sheet or sheets to group them

On active sheet go to File>Page Setup and do what you wish to the header.

Will be done to all sheets selected.

DO NOT FORGET to ungroup the sheets when done.


Gord Dibben MS Excel MVP

 

[Guest]

Hi Gord,
Thank you for your help, but still have a small problem:
as a part of my header I have a picture (logo) that wasn't copied with the
rest of the text in the header.
Do you have any suggestions what to do?

 

[Gord Dibben]

By golly......you're right.

Never use pictures or logos so did not notice this befroe now.

Graphics added to one sheet of the grouped sheets do not carry over to all
sheets.

Hang in there, someone else may come up with a solution.

I made a few stabs at VBA but still can't get it.


Gord

Hi Gord,
Thank you for your help, but still have a small problem:
as a part of my header I have a picture (logo) that wasn't copied with the
rest of the text in the header.
Do you have any suggestions what to do?

Gord Dibben MS Excel MVP