Thread: TimeStamp
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default TimeStamp

you can do it by windows, remove the rights for the users the change the
system time and date

hth

--
please click yes if it was helpfull
regards from Brazil
Marcelo



"Chris" escreveu:

I currently have a spreadsheet set up that employees use to timestamp their
login, logout, lunch, etc. I have a button on the spreadsheet and a user
chooses a cell and clicks the button for a timestamp.

There is one problem I'm running into. A clever person could change their
system time before they click the button to alter their times since my macro
is using the Now() function.

Can someone please provide me with code to timestamp from an internet
database time or something? Or if you have other suggestions to get around
this, anything woud be helpful.

Thank you.