+ Reply to Thread
Results 1 to 2 of 2

Help positioning picture comments

  1. #1
    Registered User
    Join Date
    09-20-2005
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office365
    Posts
    53

    Help positioning picture comments

    Hello all..

    I've added a picture for a comment and I'm having issues positioning the popup picture. For example, if I place a picture comment in cell C5, when hovering, the whole picture shows up, however, if i place a picture in C25, and without scrolling down in the spreadsheet, only the top part of the picture shows, the rest is below and out of sight. I'd like it so no matter where the cell is located, the entire picture comment always shows in the main part of the screen. I've tried "moving with cells", "not moving.." etc. but it's not working. Hope this question makes sense..

    Is this even possible?

    Thanks..

  2. #2
    Valued Forum Contributor
    Join Date
    01-03-2016
    Location
    Conwy, Wales
    MS-Off Ver
    2016
    Posts
    974

    Re: Help positioning picture comments

    Note - this only works if you select the cell with a comment

    Select a cell containing a comment, - macro moves the comment if it was about to appear partially hidden
    (It checks the default (top left corner) position of the comment added to its width and height against the dimensions of the display)
    illustrated in attached workbook

    Right click on the worksheet tab, select "View Code" and paste this code into the window that opens.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Kevin#; 05-09-2016 at 12:50 PM.
    If a response has helped then please consider rating it by clicking on *Add Reputation below the post
    When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)

+ 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] Positioning a picture
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2014, 07:12 AM
  2. Positioning an inserted picture from 1 sheet to another
    By cuewoz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2009, 10:36 AM
  3. [SOLVED] Comments positioning relative to cell not worksheet home
    By For the Developers. in forum Excel General
    Replies: 0
    Last Post: 08-18-2006, 02:15 PM
  4. Replies: 1
    Last Post: 01-09-2006, 02:10 PM
  5. Positioning unhidden comments for printing
    By Dusty85 in forum Excel General
    Replies: 2
    Last Post: 12-04-2005, 08:02 PM
  6. Excel Comments (Arbitrary Global Positioning Thereof)
    By SDFerris in forum Excel General
    Replies: 0
    Last Post: 05-10-2005, 07:00 PM
  7. Excel Comments - positioning
    By Paul T in forum Excel General
    Replies: 1
    Last Post: 04-28-2005, 10:06 AM

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