login name in worskheet

[nitin]

I have a workbook that many people share. I have a need to place the
name of the person who is making entries in worksheets. How do I put
login name (and time, date of entries) in a cell in a worksheet?

 

[Harlan Grove]

nitin wrote...

I have a workbook that many people share. I have a need to place the
name of the person who is making entries in worksheets. How do I put
login name (and time, date of entries) in a cell in a worksheet?

You'll need macros to do this. There are no built-in functions that
return the user's login name. One example of code for that may be found
in the following linked article.

http://groups.google.com/group/microsoft.public.excel.programming/msg/f99f9a71f1ead2c6

 

[aaron.kempf]

there are built in ways to do this; but it involves throwing away Excel
and using Access Data Projects.

SUSER_SNAME()
HOST_NAME()

etc

 

[aaron.kempf]

and for the record; don't use Excel for data entry.

it is a total and utter waste of time.

databases have the ability to use a trigger.
throw excel away and fire anyone that uses it.

 

[JE McGimpsey]

You could use Tools/Track Changes...