Which user has modified worksheet

[djfatboyfats]

Is there a way that will allow me to see the history of a user that has modified a worksheet, and if so is it also posible to find out the date and the time this was done.

Also anyone who has accessed the worksheet

I dont what to share the worksheet.

Thanks

FBF

[MarkFranklin]

Someone gave this a while back! It makes a file called usage.log in whatever directory you are working in...

Please Login or Register  to view this content.

[djfatboyfats]

Ok i have put this into a code, copy and pasted what you have gave me, but where do i go to find the information, e.g The last time it was modified, do i have to set a path for it to go to e.g c: drive?

Thanks

FBF

[MarkFranklin]

there should be a file called usage.log in whichever directory the file with code in is.....