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.