Prev: Screen Refreshing Anomaly
Next: Selection copy and insert to other sheet
From: frj5000 on 22 Mar 2010 18:57
In Excel 2007, I want to change the default format for comments, so that the
date the comment was added is included in the comment as well as the name of
the user who added the comment.
From: Bob Phillips on 22 Mar 2010 19:52
Don't think that you can, the username is all you get, the rest you add
yourself.

--

HTH

Bob

"frj5000" <frj5000(a)discussions.microsoft.com> wrote in message
news:06C2615D-AA43-4A1B-B6A3-AF551467BEE6(a)microsoft.com...
> In Excel 2007, I want to change the default format for comments, so that
> the
> date the comment was added is included in the comment as well as the name
> of
> the user who added the comment.


From: Gord Dibben on 23 Mar 2010 10:44
You cannot change the default.

You can run a macro to insert a Comment with date and time.

See Debra Dalgleish's site for code.

http://www.contextures.on.ca/xlcomments03.html#DateTime


Gord Dibben MS Excel MVP

On Mon, 22 Mar 2010 15:57:01 -0700, frj5000
<frj5000(a)discussions.microsoft.com> wrote:

>In Excel 2007, I want to change the default format for comments, so that the
>date the comment was added is included in the comment as well as the name of
>the user who added the comment.

 | 
Pages: 1
Prev: Screen Refreshing Anomaly
Next: Selection copy and insert to other sheet