Office 365 Change Log for Audit problems

Hi, I am really new to VBA and am going through tutorials trying to learn.

I have a need to complete this in a hurry though and would really appreciate some help.


I need a change log which prints onto a separate sheet within the workbook which I can protect and hide.
I need five columns: Person changing username, location of cell changed, previous data, new data (overwritten or new), Date/Time change occurred.

There is much code written on these forums which seems to address this issue entirely, however, I have tried many and spent many hours now but nothing seems to be happening.

I don't know if I am not following procedures correctly, or my version of 365 is not compatible.

If someone could give me a step-by-step instruction from start to finish to put some code in and have it run as I need I would be very grateful.

I have attached a sample of my worksheet. If any changes are made to any cell on it, I need it logged on a separate sheet within the workbook.

Best regards

Chilled Chemist

You had the code in the wrong module..

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Select Settings > Audit and logs > Audit Log Management. Select the most established review log. At that point, on the order bar, pick Delete Logs. In the affirmation message, pick OK.