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



--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40
--------------------------------------------
Share your knowledge. Add your favorite questions and answers
Help add questions to this site! We want Your input.
--------------------------------------------

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]" wrote:

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



--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40
--------------------------------------------
Share your knowledge. Add your favorite questions and answers
Help add questions to this site! We want Your input.
--------------------------------------------

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
--------------------------------------------
Share your knowledge. Add your favorite questions and answers
Help add questions to this site! We want Your input.
--------------------------------------------
"RS" wrote in message
...
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]" wrote:

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



--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40
--------------------------------------------
Share your knowledge. Add your favorite questions and answers
Help add questions to this site! We want Your input.
--------------------------------------------

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.

"HSalim[MVP]" wrote:

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
--------------------------------------------
Share your knowledge. Add your favorite questions and answers
Help add questions to this site! We want Your input.
--------------------------------------------
"RS" wrote in message
...
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]" wrote:

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



--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40
--------------------------------------------
Share your knowledge. Add your favorite questions and answers
Help add questions to this site! We want Your input.
--------------------------------------------

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

"RS" wrote in message
...
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.

"HSalim[MVP]" wrote:

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
--------------------------------------------
Share your knowledge. Add your favorite questions and answers
Help add questions to this site! We want Your input.
--------------------------------------------
"RS" wrote in message
...
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]" wrote:

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



--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40
--------------------------------------------
Share your knowledge. Add your favorite questions and answers
Help add questions to this site! We want Your input.
--------------------------------------------