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

Thread: User Name in Comments

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to get rid of the automatic username placed at the top of my comments. I have played around with the User Name designation in the tools|options|General section but the best I can come up with is putting a "space" the input box.

    This of course doesn't solve the problem it merely leaves me with a " :" at the start of my comment.

    Is there any way of disabling this or is it something I am just going to have to live with. For some reason I find most annoying.

    Thanks in advance for the assistance.

    Mike

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Are you using the comment box in just excel or through code using vba?

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

    Default

    the user name or network sign on is what you refer to , its so I you they we know who input the comments, funny when edited no new name but still.

    to remove this is can easy be done via VBA and so click command buttom not name and open to input text to that comment on the active cell,

    Sorry i cant recall how to avoid this in open play of non VBA .... i guess i really should, intrested if anyone knows.. bar sign in by cancel of cause.. no good on networks thou-
    Free Excel based Web Toolbar available here.

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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe I am wrong, but when I use a comment box in excel, I just either highlight and delete that stuff, or backspace to get rid of it. Perhaps I misunderstood the question?

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not using the VBA, have never played around with that much. Actually, just learned about it in the last 5 minutes... Heh. That route will of course be accompanied be a decent learning curve I am guessing.

    This is occurring when adding a comment through a right click then insert comment or of course through the regular menu paths.

    Thanks for the quick responses and continued thanks for future responses.

    Mike

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-23 11:31, nancyo wrote:
    Maybe I am wrong, but when I use a comment box in excel, I just either highlight and delete that stuff, or backspace to get rid of it. Perhaps I misunderstood the question?
    As do I right now. However, with programs of this sophistication we shouldn't have to do that. It is a minor nuisance admittedly, however, a nuisance nonetheless.

    Mike

  7. #7
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    813
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    nancyo you are definetely right, it is what i do to remove user name

    mikeiwo, you can goto Options_General and Change the user name with one space then you will just get ":" in your comments instead a long user name.

    Maybe you like it.


    Suat

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    He doesn't want the ":" in the comment box either, he just wants the comment in the box. I don't think this can be done outside of using VBA. If there is a non-VBA solution can someone post it?

  9. #9
    New Member
    Join Date
    Apr 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-23 11:43, teebruin wrote:
    He doesn't want the ":" in the comment box either, he just wants the comment in the box. I don't think this can be done outside of using VBA. If there is a non-VBA solution can someone post it?
    Correct.

    If someone could also be so kind to post a step by step answer in VBA so that even a complete moron could follow it that would be cool too.

    Thanks,

    Mike

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On the toolbar, insert comment will bring up a coment box on the excel spreadsheet (in a specific cell). Simply backspace or highlight and delete the user name.

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
  •