copy custom header from one worksheet to another in same workbook

A

Aamir

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
 
G

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
 
O

Orit

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?
 
G

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?
Click to expand...

Gord Dibben MS Excel MVP
 
Top