Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Fix Picture To Cell

  1. #1
    Join Date
    27th April 2003
    Location
    Middletown, N.J.
    Posts
    103

    Fix Picture To Cell

    When a picture is inserted into Excel - Insert-> Picture-> From File, the inserted Picture floats. Can the picture be tied/anchored to a given cell so that a user can not easily move it in the spreadsheet? Either an Excel or VBA solution would be very helpful. Thanks in Advance

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,302
    A partial soultion would be to attach the following macro to your picture. It will prevent casual moving. You could also add a calculate or Worksheet Change Event to your worksheet that always moved the picture to where you wanted it, but that could be overkill.
    VB:
    Sub Object1_Click() 
        ActiveSheet.Pictures(Application.Caller).TopLeftCell.Select 
    End Sub 
    
    
    Last edited by Dave Hawley; January 9th, 2007 at 13:34.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    27th April 2003
    Location
    Middletown, N.J.
    Posts
    103
    Thanks, Derk that worked. I do have a followup though. I noticed after I fixed it in place, that when I widen any row or column behind the picture, the picture grows accordingly. Do you know of any fix/code so that the picture stays the same size and does not grow accordingly?

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,302
    In the picture's properties (right click on the picture and choose Format Picture) there are several options. Select Move and don't size with cells.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    27th April 2003
    Location
    Middletown, N.J.
    Posts
    103
    Thanks Derk. What a great site this is.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Use Picture Name From a Cell
    By dickiebird in forum EXCEL HELP
    Replies: 6
    Last Post: September 17th, 2012, 05:10
  2. Replies: 1
    Last Post: April 10th, 2008, 05:01
  3. Replies: 6
    Last Post: November 19th, 2007, 17:31
  4. Replies: 5
    Last Post: January 16th, 2006, 00:32
  5. Importing: picture into a cell
    By griffinx in forum EXCEL HELP
    Replies: 1
    Last Post: June 25th, 2003, 20:10

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
  •  
porno