Freeze an Image on an Excel Sheet

[Sanjiya]

Hi,

I have an excel sheet where I would like to insert an image, however when I scroll down on up on that spread sheet (multiple pages), I don't want that image to scroll up or down, I want it to be locked and always be visible on the screen regardless of which I am on that spreadsheet. It should no appear on other spreadsheet, only the spreadsheet it is pasted on. It is not a backgroud picture; it is a reference image.

Is this possible? If so, how do I do it?

I appreciate your help!

Thanks in advance!
Sanji

 

[David Evans]

Right Click on the Image and investigate the properties - size and properties is what I get with my version of excel (Office 365) but yours may be slightly different depending on version.

When I insert a picture on the worksheet it does not move with the page, and that appears to be the default. EDIT - I think I've misunderstood your question - you actually want it to move with your scrolling ....

If you're still having issue, post your file.

Think you'll need a VBA soluition ... Attached is a file that does what I think you want - Otherwise search on "vba to move an excel image when scrolling"

Here's another place to look
http://stackoverflow.com/questions/37677537/moving-shapes-as-user-scrolls-right-in-excelvba

 

[Sanjiya]

Hi David,
Thanks for replying. I don't want the image to move when I scroll down on the sheet. I image always has to be on top and fixed regardless of what page of the sheet I am on. It is not a background page but a reference image that I always want to see on the screen even if I've scrolled down to page 25.
I have attached a file that has 4 pages. The image in on page 1 and when I scroll to page 4 the image is still on page 1 (so I cannot see it). I want to see the image even when I'm on page 4. so I want the image to scroll along.

Thanks!

 

[David Evans]

Did you try using the VBA code in the example I posted? Did it work in the manner you expected it to?

Look at the attached - every time you use Page Down to scroll it will do what you need - if you use the scroll bar, you will need to click anywhere on the page to see the image ....

 

[Sanjiya]

Hi David, I've honestly never used macros. I will be reading the how-to tomorrow and then will test the code you have provided above. Thank you!

 

[NARAYANK991]

Hi ,

Another option is to use a second window , where you can have the calendar.

See the attached file. When you open it , just click on Arrange All and select Vertical.

Narayan

 

[David Evans]

Hi David, I've honestly never used macros. I will be reading the how-to tomorrow and then will test the code you have provided above. Thank you!

At some point in time everything was new to all of us, so just keep being inquisitive and asking questions - trying and failing is a wonderful learning technique - I use it continually even though I am 61!

I'm off to Wales tomorrow, so will be off-Chandoo for a few weeks ... there are plenty of others around here who know more than I do, and are always willing to help pick you up when you've run into a wall.