Creating user/date/time log

[blaksnm]

Hey guys
My workbook "MASTER.xlsm" is activated and used by several users.
I want to create a complete cronologic log (hidden in sheet("LIST")of all accesses, by calling attributs (if they exist) as username or initials(ColumnA) /date (B)/time (C)
The log will not save the new access-data if the file is not saved.
I think the command has to be a sequence of the auto_open macro, but how will the command look like?
Can anyone guide me on this one?

 

[VoG]

You may find something useful here http://www.mrexcel.com/forum/showthread.php?t=381604

 

[Trevor G]

Create a Log sheet
Enter Titles like the following in Cell A1
User, Date, Time

Enter code in the workbook on Open Event

Sheets("Log").select
Range("A1").select
Do Until Activecell.value=""
Activecell.offset(1,0).select
Loop
Activecell.Value=Environ("UserName")
Activecell.offset(0,1).value=Date
Activecell.offset(0,2).value=Time

 

[blaksnm]

Thanks a lot both of you
This really made the trick !