Header logo

Posted on 2012-03-17
Last Modified: 2012-03-30
I need to put a header logo but not from external file, I need to copy the logo that I have in a sheet in the workbook and put it in the header of some pages.

Is it possible?

Question by:joanaplicacions
  • 4
  • 2
LVL 92

Expert Comment

by:Patrick Matthews
ID: 37733097
Excel only supports adding an image to a custom header/footer from a file.

Author Comment

ID: 37733384
If I put the image in a header sheet, is it possible to copy it to the other sheets?

My problem is that I have to print sometimes with the logo and others without it, and I need to put it again without any file, as this excel will be used by diferent users. If I get it from a file I am forced to install the logo in the same path to each pc user.
LVL 92

Expert Comment

by:Patrick Matthews
ID: 37734833
Can you put the file on a network share?
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!


Author Comment

ID: 37735174
Hello Matthews,

I can not put the file becouse is confidential and I do not think that my company would like it. I have done another file as example with the macro that I am trying tu use.

Accepted Solution

joanaplicacions earned 0 total points
ID: 37735212

Forget my question, doing the excel file for you I have found the solution. In fact it is very easy. Once you have loaded the image in the excel file, it remains even if I take it out to print without it, the only thing that has to be done to put it again in the header is to set again

.RightHeader = "&G"

and it appears!!! :)

As I thought that it was deleted at all I was looking a way to insert it again, but it is not necessary to do it.


Author Closing Comment

ID: 37786106
it works

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question