Having a bit of a nightmare with this.
I have set up a workbook with an audit log that tracks: Cell changed, sheet changed, old value, new value, date, time and username.
However, the audit doesn't work when the data is cycled by a button on each worksheet. This button simply moves top row of data to the bottom and is:
What I want the audit to log is what data was in the top row before it was cycled. It could even show what was after if that is easier.
This code works well, except it doesn't show what data is cycled by the button:
I have been staring at this for a while and no matter what I tweak, nothing seems to get the button to work with the audit.
Thanks in advance.
Bookmarks