Richard,
The code on your sheet is designed to do just that and only that, i.e. log any changes made to the sheet, though the original logs changes made to all cells. This has absolutely no bearing on F:I or L:M. These are two separate pieces of code to achieve two entirely different tasks.
All this code is doing is recording any changes to the sheet and recording those changes on the 'Log' tab. So that was all set up and working as expected.
I then had a requirement to add some additional functionality to the same sheet. Basically I needed a way to prevent users editing the figures in columns F:I and L:M (in the sample). I didn't want to protect the sheet because it would mean locking columns F:I and L:M resulting in the user being unable to insert/delete new rows, so the solution we came up with was for just columns F:I and L:M to add some Data Validation to those columns (leaving the sheet unprotected).
The way this works is as follows. This additional code (note is has been tweaked slightly since the original post) means that when a user clicks in a cell the value in that cell is shown in cell S1. Then using Custom Data Validation for coulmns G:I and L:M means that in conjunction with the code the user can only enter the existing value in any of those cells. If they insert a nre row then they can only enter zero in the cells in those columns.
Bookmarks