Create an object from an excel file to insert

[PolarBear]

Hi,

I have a company logo and info on 3 lines in an excel sheet. I want to use this as a letterhead for all excel files that I print. I want to insert this letterhead as an object into another excel file but its not working as I would like it to. When I try to Insert an Object from file and select the excel file that has my letterhead it imports ok but the object containts 10 rows, 3 of which is my letterhead and the rest just empty rows. I just want those 3 rows and 5 columns to be imported. Setting the print area of the letterhead file doesn't make any difference.

If I'm not clear enough of what I want to achieve, I can explain it more clearly.

Thanks

[Gord Dibben]

Pbear

Select the range in question and SHIFT + Edit>Copy Picture.

Open clipboard and save as a picture.

You can use this graphic as the Header for all sheets in all workbooks.


Gord Dibben Excel MVP


On Mon, 7 Nov 2005 14:32:22 -0600, PolarBear
<[email protected]> wrote:

>
>Hi,
>
>I have a company logo and info on 3 lines in an excel sheet. I want to
>use this as a letterhead for all excel files that I print. I want to
>insert this letterhead as an object into another excel file but its not
>working as I would like it to. When I try to Insert an Object from file
>and select the excel file that has my letterhead it imports ok but the
>object containts 10 rows, 3 of which is my letterhead and the rest just
>empty rows. I just want those 3 rows and 5 columns to be imported.
>Setting the print area of the letterhead file doesn't make any
>difference.
>
>If I'm not clear enough of what I want to achieve, I can explain it
>more clearly.
>
>Thanks

[PolarBear]

Thanks, that works but when I print the logo image is really bad quality. The text comes out fine. The picture object look identical in excel. Its only when I print it.