Create an object from an excel file to insert

P

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
 
G

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
 
P

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.
 
Top