Track & Record changes

[galvinpaddy]

Afternoon happy campers!

My situation:
Workbook consists of around 10 sheets (departmental time sheets) I have already set certain ranges on each sheet to be protected and other not, so when i password protect the sheet only some ranges can be changed, i have also added VBA to look at the users name opening the sheet, and if it matches one of the defined names, then all protection is removed.
We will have approx 5 different users modifying this workbook.

My request:
How can i get VBA to log what user, makes what changes to what sheet at what time/date.

Initially it sounded really simple, but im beginning to realise its most likely not a straight forward thing to do

I would like the data to be collated onto a sheet (within this same workbook) that is always hidden from view and is locked/unlocked in line with the VBA in place.
Ideally, the data will be along the lines of:

User - Tom Jones, changed K21 from 12:30 to 12:45 - 11/02/14 @ 13:50
User - Jim Bob, changed A1 from in to out, changed c17 from days to nights.

This sort of thing, does not have to remain in the same layout as above at all, just easy and simplistic to understand.
Is this possible? and if so, would any one like to have a bash at it for me?

Kind regards.

[AndyLitch]

Done a couple of identical ones before it's easy when you know how
Can you upload your workbook?

[galvinpaddy]

i could but will take a while to remove all sensitive data
Is there no code that can simply track changes where ever the changes occur and keep the record on a seperate tab?

[AndyLitch]

Put the following code into the worksheet code module of all sheets you want to track

Please Login or Register  to view this content.

Put this Code in a code module

Please Login or Register  to view this content.

Create a new worksheet called EditLog