Good morning,

Could anyone offer some method to solve the following:-

I have set up a workbook containing 7 worksheets, 3 of which need to be locked for individuals to edit.

I have achieved this, by using the 'allow users to edit ranges' with each of the ranges being allocated to an individual...

However i need to be able to track the changes made by these individuals...

Is this possible, as the track changes function only tracks the individual that is login into the computer (everyone uses the same generic login)

Thank you