looking for helps about trancking changes by VBA

[liusuzanne]

Hi everyone,

My workbook has 1 sheet for raw data and 4 sheets for the calculating results by using VBA.
Somebody can help me to develop an additional Macro program for tracking all changes made only in the raw data sheet, including add or delete a row/column, modify a cell value and etc. All of these changes will be recorded in a real-time mode in a dedicated worksheet of the same workbook once it is saved. The dedicated worksheet will include the essential information like that provided by the Excel built-in tracking change function. Basically, there are the change date/time, the author (user name came from the computer login session), the modified cell/row/column, the action, the original value and the new value. The records generated cannot be cancelled or modified in this sheet.
In addition, it should be better to have a column in the same sheet in which we are permitting to add any comments related to the modification.
May I have a help from your expertise, please? Any suggestion is welcome. Thank you very much.

[1aaaaaaaaaaaaaaa]

Hello,

Do you have a sample workbook that we might be able to look at? Remove any sensitive data of course


Thank you.

[liusuzanne]

See it in the attachment.
There are 7 sheets totally. The sheet menu is for locating the Macro control buttons. The sheet Bd is a row data sheet that I would like to track changes. The 5 other sheets are genereated (copy or calculate by using 4 differents VBA codes).
Thanks so much.