ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to rid of User name from Comment Notes? default now (https://www.excelbanter.com/excel-discussion-misc-queries/185635-how-rid-user-name-comment-notes-default-now.html)

lbbss

How to rid of User name from Comment Notes? default now
 
For some reason excel is setup to input my user when ever I insert a
comment note in a cell. So each time I have do delete the user name,
before inputing my comment. Is there a setting in excel to take that
option off. thanks.

FSt1

How to rid of User name from Comment Notes? default now
 
hi
unless they have changed this in 2007, no.
comments were added to work with shared workbooks so that each user who
shared the workbook would know who added which comment. excel adds the
default user name to each comment from the pc the comment was created on.
you can change your user name on your pc(toolsoptionsgeneral tabuser
name) to something like Note: or other but excel will put something there.
you may have luck deleting the name programicly. see Debra's site on
comments.
http://www.contextures.com/xlcomments03.html#OldName
replace "old name" with "".

regards
FSt1
"lbbss" wrote:


For some reason excel is setup to input my user when ever I insert a
comment note in a cell. So each time I have do delete the user name,
before inputing my comment. Is there a setting in excel to take that
option off. thanks.



All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com