Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Moving Comments Boxes

    Hi,

    I have a Spreadsheet with a number of comment boxes that I need to stay in the location that they have been left in. It seems that every now and then the position and size of the comments reset back to a standard (where the comment sits to the immediate right of the cell where the comment has been placed) and covers up some of my data.

    Is there a way that these can be set to stay where they are and stop jumping about?

    Thanks

    Alba.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am not sure this is the problem, but when Visible comments can be relocated and they should remain there unless moved/reset. But if moved when visible, if a comment is made not visible, when it "pops up" it is the default location, not the relocated position.

    Steve

    PS. If you copy a cell with a visible comment, it also resets the location, moving it keeps the distance relative.
    Last edited by sdckapr; 2011-06-20 at 12:16.

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,199
    Thanks
    48
    Thanked 987 Times in 917 Posts
    Re-sizing cells can also upset positions.

    cheers, Paul

  4. #4
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there no way that the location of the comments boxes can be 'locked' - or would I be better to use text boxes that should stay where they have been placed?

    Thanks

  5. #5
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,199
    Thanks
    48
    Thanked 987 Times in 917 Posts
    You need to control the cells where the comment is shown, not the comment.

    cheers, Paul

Posting Permissions

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