Microsoft Office Tutorials and References
In Depth Information
Logging Actions When a Cell Changes
Logging Actions When a Cell Changes
This procedure demonstrates how to store specific information, such as the
workbook name, worksheet, range, user, or date, whenever a cell changes in a
workbook.
Example file:
E040.xls
Scenario: Using the Track changes feature can help
tremendously, but because it has to share the workbook as well,
you may encounter limitations that Excel can't handle (such as
protecting or unprotecting a sheet, changing data validation
settings, etc.). When used to simply track who made which
changes and where they made them, this macro will create a
text file (which can be saved on a network server), with useful
information such as the worksheet name, the cell(s) that
changed, who did the changes and when the changes
happened.
Exl
Figure 41 – Log Actions (Before Logging)
 
Search JabSto ::




Custom Search