Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
making NT user/login user appear in a cell
Hi! I'm using excel 2003 and trying to create a time-keeping
worksheet. I created a workbook in a shared folder wherein all the members in my team can access the file and encode their own time-in and time-out from work. To check if the time they encoded in the file is the actual time they came in, I placed a date and time stamp formula + a macro that would make changes in the date & time stamp which automatically reflects in another column every time a change is made. My problem is, how can I make the NT user ID of the person who edited a cell appear in another column/cell? I need that particular NT/user ID to appear directly in a separate cell just like how a date/time stamp work. Is that possible? I got my macro for the date/time stamp from the link below: http://www.mcgimpsey.com/excel/timestamp.html I can't use the "Track Changes" command from the Tools tab because if I do, I get a pop-up message that the macro won't work if I share the workbook to be able to track changes. Basing on the conversation of Raz and Davvid McRitchie (http:// groups.google.com/group/microsoft.public.excel.worksheet.functions/ browse_frm/thread/af2de113a3985b8d), I tried using the macro David suggested but the NT user is still not appearing in the actual worksheet file. Is there a formula needed to be encoded in the cell where the user name stamp should appear before I put in the macro? How can I combine the date/time stamp macro with David's suggested application user name tracker macro? Please help! Newbie here.... ^v^ thanks! -patti |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to automaticaly insert user name (login name) in excel? | Excel Worksheet Functions | |||
Open Specific Form by User Login | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
How do I automatically insert the user (login name) in Excel? | Excel Discussion (Misc queries) |