Tracking Changes Excel

**hassankhan** · 03-22-2010, 03:34 AM

Would it be possible to track changes made to specific cells in a spreadsheet. Ids for the users IDs are all set.

Example

2 Users (A, B)

A, made a change to cell A4 and saved the sheet. B4 would say last changed by "A" at " "Time, Date"

**Marcol** · 03-22-2010, 05:01 AM

This will work on the worksheet you place the code.

It is only an example it will work for all cell changes as it stands.

You will have to limit it to the cells you want and consider protecting the sheet.

Paste this in a worksheet module in VBa

Please Login or Register  to view this content.

EDIT:

Hold that result wrong username that's just who the copy of office is registered to

See Post #4 for explianation

**hassankhan** · 03-22-2010, 06:07 AM

* Slight modification

I would like this to work in the background. It would track changes on Sheet1 and would be entered into Sheet1.

Right now, the change is offset by 0,1. I would like it to be offset 0,1 on Sheet2 and not one.

Thanks

**Marcol** · 03-22-2010, 07:13 AM

In Sheet2 put the following Headers beginning A1

Old Value, New Value, Cell, Changed on at by

Paste all of this code into Sheet1 worksheet module

N.B. OldVal / NewVal must be declared outside of the procedures as shown.

Please Login or Register  to view this content.

EDIT:

Hold that result wrong username that's just who the copy of office is registered to

Give me 10mins Sorry

EDIT:

Corrected the code above rather than leave an error on the BB

**Marcol** · 03-22-2010, 08:11 AM

Hi Again

This avoids the API call.......simples!

Please Login or Register  to view this content.

N.B.

The function Environ() is Not Available to Macintosh users.

Multi-Cell selections, filldown, multi-delete, delete row, etc. These changes will not be Audited. To cover these conditions much more coding is required.