Track Changes

[vikesh]

Dear all,
Plz help me out in this problem. I have a excel file that has been kept
on a network (we call it G drive).
Access to this file is restricted by the system administrator.
Only one person uses this file at a time - since if any other opens it,
it shows a read only notification.
My problem is how do i know that :
1. what changes were made

2. by whom it were made

3. when they were made

4. Also i want a listing of these changes made so that in future if
they are required then it can be extracted easily, instead of going to
all the persons and asking for what changes have been made.

I have been searching the solution for this problem since long.

Thanks in advance,

Vikesh

 

[Frank Kabel]

Hi
reading your requirements the build-in function 'Tools -
Track changes' is probably not sufficient for you?

For all other requirements you have to implement such a
tracking on your own in VBA (but this could get
complicated esp. if you need an audit trail).

 

[vikesh]

Is there any tutorial available on the subject of track changes (wit
examples). since F1 help seems to be too complicated