Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
the now() function
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |