Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Current date in the comment instead of the user ID Gary[_2_] Excel Worksheet Functions 1 October 22nd 07 11:11 PM
Change default font for notes? Jennifer Setting up and Configuration of Excel 1 June 18th 07 07:39 PM
How do i format a default comment Trainman Excel Worksheet Functions 1 February 28th 07 03:57 PM
Add User to comment Nimish Excel Discussion (Misc queries) 0 August 17th 06 08:41 PM
How do I set up the default format for a comment? Gitesh Excel Discussion (Misc queries) 1 April 1st 05 11:18 PM


All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"