View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default the now() function

Bill wrote:
I want to capture the date & time when a user signs in, how do I move it to
a secure field where it can not be changed or updated.



Have a look at this (note: macros are in workbook!):

http://vfdrake.home.comcast.net/~vfd...save_audit.xls

This captures the user and timestamp on a save event to a hidden
worksheet. This can easily be adapted to capture an open event. Saving
the results are up to you.

Note this is "security by obscurity" and can easily be defeated by those
in the know. Especially so if their macro security is set to medium or
high. There are ways to coerce folks to enable macros in Excel, but in
the end Excel is not a hammer-safe app.