+ Reply to Thread
Results 1 to 10 of 10

Image not showing on part of worksheet

  1. #1
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Image not showing on part of worksheet

    I have a workbook with 5 worksheets which I run a macro to insert an image of my signature. One worksheet, the image is visible, but lower down, it is visible onscreen, but when I print, it is not there! If I take the image from above and drag it down to be half on one page and half on the other, only the top half shows! There are two other worksheets the same layout, but the image is visible on all locations. I have checked all the settings I can think of and everything is the same. Any ideas? It's like that page won't allow images. Thanks for any replies!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Image not showing on part of worksheet

    Hi,

    Are you sure the print range covers all the rows down to the one immediately below your picture?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Image not showing on part of worksheet

    For sure! I have a macro which prints to pdf, so the page prints, just not the image.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Image not showing on part of worksheet

    Are you able to upload the workbook so that we may check the question in context?

  5. #5
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Image not showing on part of worksheet

    Here is the culprit page! As you move the image down to page three it will disappear when you unclick from it.
    Attached Files Attached Files

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Image not showing on part of worksheet

    Hi,

    I'm not clear what you are expecting to see and why you think there is anything amiss.
    The picture is overlaid on top of the text on page 2 (not sure if that's what you intend since of course the text is hidden). It does not straddle the page 3 page break

    Hence I'm not sure why you think something is wrong.

  7. #7
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Image not showing on part of worksheet

    It's just what I put up for example. Yes, it shows onscreen on page two, but drag it down to page three and unclick and viola, it disappears! Drag it halfway over page two and three, then go to print preview and you will see the top half on page two and nothing on page three of the picture.
    Last edited by thecdnmole; 09-29-2014 at 08:11 AM.

  8. #8
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Image not showing on part of worksheet

    Hi,

    I am not sure,

    Try this select Image -> Bring to front -> Bring to Front.

    Punnam

  9. #9
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Image not showing on part of worksheet

    Try Unhiding the hidden row 106 and/or temporarily changing the zoom whilst you drag the picture down.

  10. #10
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Image not showing on part of worksheet

    I removed line 106 from that page and it appears to work!! Strange tho as two other identical pages also has that hidden line and the image appears on page three with them. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to transfer image FROM userform image control TO a worksheet cell
    By Zoediak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 02:51 PM
  2. showing/hiding an image with a button
    By redbullah in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2010, 12:21 PM
  3. Image not showing in Print preview
    By jarv in forum Excel General
    Replies: 3
    Last Post: 01-23-2009, 08:52 AM
  4. Showing an image from the web
    By jimmisavage in forum Excel General
    Replies: 2
    Last Post: 12-15-2007, 11:13 AM
  5. Hyperlink to an image in other worksheet, displaying entire image.
    By twilliams in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-07-2006, 06:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1