+ Reply to Thread
Results 1 to 3 of 3

How do I keep my name from appearing in the comment box in excel

  1. #1
    Old Abuelo
    Guest

    How do I keep my name from appearing in the comment box in excel

    How do I keep my name from appearing in the comment box in excel?

    When I open the comment box in Excel it automaticaly includes my name. How
    can I prevent this or better yet how can I set it up to enter the date
    instead of my name automaticaly?

    Thanks.

  2. #2
    Jon Peltier
    Guest

    Re: How do I keep my name from appearing in the comment box in excel

    This automatically appears when you manually add a comment, but you can
    delete this text. You can't change what appears in the status bar when a
    comment is visible ("Cell A1 Commented by User Name") after the comment is
    created.

    You can change what appears in both places by changing the user name under
    Tools menu > Options > General tab.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______


    "Old Abuelo" <Old Abuelo@discussions.microsoft.com> wrote in message
    news:6E08BEB2-28B4-4E99-A728-7F0EF8B8A2F1@microsoft.com...
    > How do I keep my name from appearing in the comment box in excel?
    >
    > When I open the comment box in Excel it automaticaly includes my name. How
    > can I prevent this or better yet how can I set it up to enter the date
    > instead of my name automaticaly?
    >
    > Thanks.




  3. #3
    Ragdyer
    Guest

    Re: How do I keep my name from appearing in the comment box in excel

    You can easily remove your name from displaying by:

    <Tools. <Options> <General> tab,
    And replace whatever's in the "User name" box with a <space>.

    However, this does leave a colon in place of the name in the comment .

    If you wish to use code to effect changes, Debra Dalgleish has a number of
    choices at this web page:

    http://www.contextures.com/xlcomments03.html

    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "Old Abuelo" <Old Abuelo@discussions.microsoft.com> wrote in message
    news:6E08BEB2-28B4-4E99-A728-7F0EF8B8A2F1@microsoft.com...
    > How do I keep my name from appearing in the comment box in excel?
    >
    > When I open the comment box in Excel it automaticaly includes my name. How
    > can I prevent this or better yet how can I set it up to enter the date
    > instead of my name automaticaly?
    >
    > Thanks.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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