Hi again Frank,
I KNOW THAT! I can get round that! I'm not dealing with experts, if I were
it would be a different matter. I can easily make the workbook useless
without Macros Enabled.
I could easily overcome that as could you, but the people I'm dealing with
would not even try, its not a matter of National Security,
Regards and Thanks,
Alan.
"Frank Kabel" wrote in message
...
Hi
as said you can do something in your workbook open event BUT if the
user disables macros it would be useless

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
Hi Frank,
I do know that as I said originally, but I don't have access to the
operating system on the Company Network and the IT people I deal with
are less than helpful. Is it possible within Excel?
Regards,
Alan.
"Frank Kabel" wrote in message
...
Hi Alan
I would not do this within Excel (the easiest way to circumnvent the
logging is to disable macros). Do this on operating system/network
level.

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
Hi,
I'm using a Windows Networked company system where users each have
their own private bit of the hard drive and also a Public Drive
which anyone can access.
On this Public Drive are several read only Excel Files that
multiple
users access on a regular basis.
My query is, would it be possible to obtain a log of who has
accessed these files and when? Obviously the files would not be
saved on closure as they are read only.
If this isn't possible, could it be done if the files were saved,
ie
not read only, or even with a Workbook close event to force a save?
(I know that wouldn't work if the files were opened with Macro's
Disabled, but that wouldn't really be a problem)
Any advice gratefully received,
Regards,
Alan.

Office XP
Wndows NT (I think!)