1. Jyggalag

    Making a frontpage in Power BI?

    Dear all, I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :) I currently have the following Dashboard: Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...
  2. O

    Document Header and Footer images placed in exact locations in bulk

    Hi guys, I'm currently changing the logos in bulk for 1000s of documents and know there to be an easier way to do this. I have some template documents which contain the right header and footer placements for each of the images, but I, so far, have not been able to translate this into bulk...
  3. O

    Code to delete unused cropped region

    Hi there, My goal is to delete the cropped space of images that is currently unused. That is, after an image has been cropped, I want to use "compress picture" function in excel/word/powerpoint to batch process this over multiple files. My problem is that I can do this just fine in excel...
  4. D

    Can you freeze from a certain cell when that cell gets to the top of the page

    I have a spreadsheet that has a rather large logo at the top. The logo is of where I work and I want the screen to rows 5:10 to free at the top of the screen so they will always be visible but anything above row 5, I want to scroll up as you go down the page. How do I do this?
  5. C

    Adding logo to multiple worksheets

    Hi All, I am using the code below to add logo's to multiple worksheets. It works great until I send the workbooks to my colleagues. The logo isn't visible for them, I believe it's because it is creating a link to the picture in my own personal drive, I want to embed the logo, could I change the...
  6. T

    Is it Possible to have excel show a different picture when it open than the excel logo?

    HI Everyone, Quick question. I've seen lots of software documents in the past that use excel as there engine but are made to look like a unique document. Is this easy to do, are there guides i can follow or is this too hard???? for example when you open the document insytead of it showing...
  7. D

    VBA Adding image to PDF file

    So I can create pdf from worksheet fine, but it does not show my logo image. What do I do to add to ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ FileName:=pdf_expenseName, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _...
  8. D

    pictures disappear

    I have a workbook that we do our estimates in. Our logo(jpg) is in the upper right hand corner of each page. That space(logo, company header) is locked and the sheet protected. So that space cannot be accidently be changed. Randomly the logo vanishes on all 3 pages. It is placed in the...
  9. H

    Logo Getting Squashed

    For some reason, my logo is getting slightly squashed when it is printed. It looks correct on the screen. I've got the logo in the header on the top right section, the "Scale with Document" box is unchecked, "Lock Aspect Ratio" box is checked, and "Relative to original picture size" is also...
  10. G

    Conditional header and footer image

    Hi everyone, Need your assistance on conditional header and footer. I want a macro in which if my cell "D2, D3..... Dn" is empty, it should not show header and footer or else if it is not empty, header and footer should should show logo. The logo is in picture format and saved in the desktop...
  11. S

    Excel 2013 stripping out buttons and jpg images

    I am finding that as I convert workbooks from excel 2002 to 2013 or newer, there are times when saving the workbooks gives me an error message. This is sporadic and does not happen every time the workbook is saved. The message basically warns me about corruption of the file and excel has to...
  12. M

    macro to change footer logo based on embedded image

    Hello, I'm new to the message board but I have been unable to find an answer to my problem. I have a project workbook (used by several people) that produces reports for multiple companies. Each report needs to have the company logo in the footer section when printed. Currently I have the logo...
  13. T

    Removing logo from Excel spreadsheet

    Hi, I am using a quite complicated spreadsheet at work(engineering). I am trying to get rid of the logo, however I can't remove it (I am not very experienced in Excel). The link to the spreadsheet is...
  14. S

    Printing header or footer image appears on top of text

    hi im new to this forum although I have learned a few things from it when searching. I did a lot of googling but there seems to be no answer for this - If it's there I haven't been able to find it. Basically I would like to create a washedout or transparent image behind my invoice table. The...
  15. U

    Changing a Macro Button to a company Logo

    Hi, I have a dashboard tab with a number of buttons which take the user to further details on the companies being examined. I'd like to change the macro buttons on the tab to company logos. Is this possible? The company logos would just be PNG images ripped from the net. Kind regards, Ross.
  16. S

    Macro VBA to Change Logo on Multiple Workbooks - Help

    Ok so this out of my depth a little since i'm a beginner at macros and VBA's...so here is my problem: I have a folder full of workbooks (delivery notes) for each of our customers. Each workbook contains our old logo at the top Since we have now re-branded i wondered if we could use a macro to...
  17. P

    Batch replace image(s) in multiple files and sheets

    Hello Everyone, First, I haven't found my answer in other threads, so if it does exist, please redirect me. Now, here is my problem. I have thousands of excel files each containing a varying quantity of sheets. There are two logos in each file first sheet (at the same position) and these...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back