Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Changing comment position ?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is it possible to change the position of the red triangle in a cell that denotes a comment ?

    My worksheet is restricted to only a couple of columns and the comment in the last column displays outside of the users viewable area. Is there some way of making the comment display to the Left of the cell as opposed to the right as standard ?

    Thanks
    Bill

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    San Ramon CA
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    eek. that's a tricky one.

    If one could test the cells in question for the presence of a comment, then VBA could alter the border around the cell (color, line thickness, etc). Food for though for the VBA gurus, I suppose.

    Personally I'd just as soon expand the viewable area to one more column, and shrink that column down so it looked more like a border (1 character wide). Then you'll see the comment 'flag' but not much more.

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    As far as moving the comment to the left, YES, just click on the comment object, and with the 4-headed arrow, move it to the desired location -- it will still have the arrow line pointing back to the top right hand corner of the commentel cell.

    regards!

    Yogi Anand

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yogi .. do you mean use the "edit comment" option then position the box using the arrow ? .. I have tried that and yes it does move the box .. but only for editing .. under normal user-viewing .. the comment box still pops up in its original position ie to the right of the cell

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I imagine you are using Comment_Indicator option -- ya! in that case the box does not stay in the moved location.
    However if you choose the Comment_Indicator and Comment option from Tools|Options|View|Comments -- you can have the comment stay visible all the time and you can have it located to the left side and it will stay that way.

    regards!

    Yogi Anand

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OH .. I see now .. yep I've just tried that .. but it displays all the other comments permanently and I have many more .. they're all over the place .. lolol

    so .. that wont do I'm afraid .. is there anything else I can try ?

    Thanks for your help
    Bill

  7. #7
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes that's right -- it's all or nothing. You could try a text box for this particular situation-- and the text box can be located in any position you like, and can stay on all the time if that's you rdesire or even that you can hide or display as an object.

    Regards!

    Yogi Anand

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    refering back, i have tried for years to do this or even change the colour and size of the comment FLAG

    FAILED. i ve asked all my guru VBA coders many on this board, no one of them ever fails to reply to my emails

    all said nope, sorry, errr, and i tried..

    from that i state, with styrength NO this can not be done the flag fly as she likes and no one can change her!

    please prove me wrong!

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if all else fails, you could use the camera

    take a snapshot of the cells where the comment pops up (ie the ones that are offscreen)

    then pop the image to the left of your cell with the comment in it

    right click the image and format it with no border lines

    then drag the image so it aligns up perfectly.

    Beilieve it or not, when the comment appears on the right, it also appears on the left.

    The downside to this (and it's a big one) is that the image sits on top of the cells underneath which can't be utilised normally, which may be unacceptable.

    here's how to get the camera :

    view
    toolbars
    customise
    commands
    tools.......... scrolldown the options

    click the camera icon and drag it to your toolbar, you should now have a camera sitting on your toolbar

    now highlight your cells in question and click the camera, this will take a snapshot of those cells

    now go to where you want to show them as an image, click and drag to max size

    :: Pharma Z - Family drugstore ::

  10. #10
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jack,

    I thought you'd said recently that you've managed to change the red comment triangle to green. I could be wrong though.

    Hey, on a side note (off topic). Have you changed the way you post recently? I know you've had comments about the readability of your posts, but you've put together some really clear posts lately. (this is a compliment BTW)

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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