Storing current dates and system username on a cell

[Ify]

I need a code either a formula or better still a sub procedure o
function for storing a current date value which cannot alter after tha
date and the username(from the system) on a cell automatically onl
after the user has clicked the saved button.


For example


Date (to be automatated) :username(to be automatated)
08/07/2004 : Jo freazer
09/07/2004 : Kelly hamburger
10/07/2004 : Tai Azi
11/07/2004 : Kelly hamburger



Thank yo

 

[Township of East Hanover]

http://www.j-walk.com/ss/excel/tips/tip94.htm

http://www.j-walk.com/ss/excel/tips/tip95.htm

Try a combination of the above tips. This stores the log in a different file
from your spreadsheet. that way the users don't know it's happening and they
can't see it in the spreadsheet.

 

[NewsGroups]

I need a code either a formula or better still a sub procedure or
function for storing a current date value which cannot alter after that
date and the username(from the system) on a cell automatically only
after the user has clicked the saved button.


For example


Date (to be automatated) :username(to be automatated)
08/07/2004 : Jo freazer
09/07/2004 : Kelly hamburger
10/07/2004 : Tai Azi
11/07/2004 : Kelly hamburger



Thank you

Have you tried using the formula NOW() in a cell within a macro
routine and then Paste Values on the same cell, which you seem to have
as you mentioned the user clicking the save button.