LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
 
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
How to automaticaly insert user name (login name) in excel? dheitz Excel Worksheet Functions 7 April 3rd 23 01:21 PM
Open Specific Form by User Login Bowtie63 Excel Discussion (Misc queries) 1 November 30th 07 12:21 AM
How do I format a cell, so the user must use a user calendar? nathan Excel Discussion (Misc queries) 1 January 16th 06 06:40 PM
How do I format a cell, so the user must use a user calendar? nathan Excel Discussion (Misc queries) 0 January 16th 06 05:26 PM
How do I automatically insert the user (login name) in Excel? ABlazer Excel Discussion (Misc queries) 1 September 19th 05 02:48 AM


All times are GMT +1. The time now is 11:16 PM.

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"