login name in worskheet

N

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?
 
H

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
 
A

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
 
A

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.
 
Top