bbold

Hi all I have the code below which should record changes to cells in a worksheet - recording cell, old value, new value, time, date and domain name of person that made changes. It works well, except: 1. the old value is never recorded and just shows a blank. how do I record the old value...

hi using the code below to record changes to cells in a worksheet called "Master List"; it works almost perfectly except it doesn't put the old cell value into the tracker, but instead "Empty Cell". Most of the changes to be tracked are changing text / numbers to text / numbers but it always...

This is my first question on this website but I've been using this site for a while now teaching myself basic VBA skills...thank you all so much! Now to my question... I'm looking to have a macro that will track any change on any worksheet. I've found code that does this but it only...

Hi, I use the following code in a spreadsheet. Within the code it unprotected the worksheet and then protects it once it has run the macro. I need to, when protecting again, ensure that the use of auto filter is permissible. For some reason, each time it protects, my auto filters will not...

Hi, I am using this code to track work changes on a sheet. Everything works perfectly apart from the tracking of the old value. I see what the value has changed too, but It will not show what the value has changed from (old value). Option Explicit Dim vOldVal 'Must be at top of module...

Hi, I am using VBA code to track changes to an excel spreadsheet, currently recording Cell changed ref Old Value New Value Time of change Date of Change I need to add Who changed it (Windows username). The code I need to add to is below, would be great if someone could assist with this...