Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Changing comment position ?

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

    Default

    i could go off you Chris!

    dam times you snarl, did you try my camra trick, nope i grumply say,

    again your right!

    i should really learn, frightening thing is i just know this will work arround just fine....

    a very big BIG thanks Chris... a quality fix!

    Free Excel based Web Toolbar available here.

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

  2. #12
    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

    I'd noticed that too... are your fingers healing now Jack ?


  3. #13
    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

    cheers.... it's really a last resort though, it has some serious drawbacks.

    Pretty nifty though, comments popping up both left and right !

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

    Default

    fingers are broken not the bone the tipof the bone so bit floats about and other messy twisted, to many times i guess.

    Dr warned me no more impacts or my hand cpuld colaps.. should see the xray, every joint is damaged, to may heads i have hit i guess.

    but they stil hurt and anoy me, but ive tested them in case of troubles in my streets and im fine, just have to not mess about - just keep it business.

    Funny people are generally nice and polite tome when im out, cant think why im super polite as you expect...

    pop up both side well i fancy it what you do is have the all over the place i guess.

    you idea the camra and i feel some heavy exploting needed of this gadget, ido not feel it have been exchausted but a long way

    cheers chris, also i won 2 1 sunday, you know my team never looses regardless of what side im on!


    Free Excel based Web Toolbar available here.

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

  5. #15
    New Member
    Join Date
    Mar 2010
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: Changing comment position ?

    If your excel comments have moved out of position, you can reset them to there original position by using the following code:

    Sub ResetComments()
    Dim cmt As Comment
    For Each cmt In ActiveSheet.Comments
    cmt.Shape.Top = cmt.Parent.Top + 5
    cmt.Shape.Left = _
    cmt.Parent.Offset(0, 1).Left + 5
    Next
    End Sub

    Regards,
    Mohammed Ali
    http://daily-exceltips.blogspot.com/

  6. #16
    Board Regular
    Join Date
    Jan 2009
    Posts
    828
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Changing comment position ?

    Have you tried DATA VALIDATION...where you can include a comment that will appear when the user hovers the pointer over its area?
    Humpty Dumpty was pushed

  7. #17
    Board Regular Jaafar Tribak's Avatar
    Join Date
    Dec 2002
    Location
    Larache--Morocco
    Posts
    6,573
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Changing comment position ?

    I posted some code HERE that dinamically changes the position of comments to the left when pointing the mouse over the cell .

    It uses a background loop which kind of has a performance hit.

    If anyone is further interested in this , I can adapt the code so the loop runs in an out of process VBS file and doesn't affect the workbook performance.

    Regards.
    Office/Excel 2010 64Bits -- Win10 64Bits

    Common sense is not so common.


    http://photo-larache.blogspot.com/

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
  •