Listing opening dates of files

P

peted

I would like to list the dates that a file has been opened and possibl
who openned the file. Is there any way of doing this
 
C

CLR

Excel "records" the date a file was saved, not when it's opened. Anything
else you might have Excel do, such as recording who opened the file and when,
etc, depends on the operation of macros. If the user does not enable the
macros, you have no control. To do as you wish, you would need VBA code
controlling the initial viewing of the file unless macros were enabled, and
when they are, then to do an immediate capture of pertinent data and save,
thereby recording such items regardless of whether the user intentionally
saves or not.

hth
Vaya con Dios,
Chuck, CABGx3
 
C

CLR

I presume so, but only with Macros enabled........I have never done this
specific thing myself, but it seems feasible. You would have to set up a
dummy start-up screen with all other sheets hidden. This screen would inform
the user that the rest of the file cannot be viewed unless macros are
enabled. You would also need Before-print, and Before-save macros, and maybe
Change-event macros to automatically make entries into a log which could be
contained within the file and hidden from regular-user view, or the macros
could call up another file and transfer the log to it.

But keep in mind, if you are interested in privacy..... that you CANNOT make
the file secure from those individuals of significant Excel abilities. You
can only make it confounding enough that they may give up trying........

hth
Vaya con Dios,
Chuck, CABGx3
 
Top