Logos in Excel

[HSalim[MVP]]

Hi,
I have two logos that I want to put on each sheet, one on the top and one on
teh bottom.
The person who originallly designed this workbook had the data on different
tab, each a page long and
placed the logos on top and bottom.
However we are forcing the data on one page using shrink to fit. This
causes the logo to be inconsistent, and the placement is not exact.

I could place the logo on the header and footer.
For taht I would have to browse to the file and attach it. If I distribute
the file, say email it to someone not on the network, would i have to send
the images as well?
Could I add the logos to the shapes collection, store it in a hidden sheet
and put it on the header/footer via code?
Is this a bad idea?

Thanks in advance
Regards
Habib

 

[RS]

Dear Habib,

Once you paste the logo into your spreadsheet, it becomes a part of that
spreadsheet so you do not need to e-mail the logos separately. I myself have
a logo that I pasted into my spreadsheets and whenever I e-mail the
spreasheets, the logo stays with them.

 

[HSalim[MVP]]

RS,
Thanks for the quick reply. That was vey helpful.

This is just a curiosity question - I have already added the logos to this
file.
Since I have multiple sheets, I had to add both logos searately to the
header and footer for each sheet.
I tried selecting all worksheets and adding the logos once but that did not
work. Is there a way to add logos or info to the page header for multiple
sheets in one go?

Also, the file size does not change significantly even as I added 16 logos.
I wonder if XL does re-use the logo internally.

Regards
Habib

--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40

 

[RS]

Dear Habib,

Offhand...it doesn't look like there's a straightforward way to add the
logos to multiple sheets at once. However...that doesn't neccessarily mean
that there isn't someone out here that might know some programming code that
would do what your asking. You could try posting this question in the Excel
Programming area and see if anyone knows code to do that. Good luck.

 

[NickHK]

If your printer supports Watermarks, that would be easier. Then you do not
need code; just leave it to the printer to add the logo on each and every
page.

NickHK

Dear Habib,

Offhand...it doesn't look like there's a straightforward way to add the
logos to multiple sheets at once. However...that doesn't neccessarily mean
that there isn't someone out here that might know some programming code that
would do what your asking. You could try posting this question in the Excel
Programming area and see if anyone knows code to do that. Good luck.