Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking changes in excel
I am trying to track changes that I am making to a workbook. This workbook
has 4 different worksheets. This workbook also has links in it so everytime I go from one worksheet to the next it updates these links and then shows as if I made changes to it when I didn't. When i go to tools and track changes I've tried to choose the "where" but it only allows me to chose one worksheet to select my criteria. When i try to put multiple sheets in the "where" it says that my reference is invalid. Anyone have ideas? Also, is there anyway to track changes like they track in microsoft word? This would be even better and looks much nicer for what I am doing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking changes in excel
Try this exsample:
make a sheet e.g. Spy put this code in all other sheets code-module Private Sub Worksheet_Change(ByVal Target As Range) Sheets("Spy").Cells(Sheets("Spy").Cells(65500, 1).End(xlUp).Row + 1, 1) = Now Sheets("Spy").Cells(Sheets("Spy").Cells(65500, 2).End(xlUp).Row + 1, 2) = ActiveSheet.Name Sheets("Spy").Cells(Sheets("Spy").Cells(65500, 3).End(xlUp).Row + 1, 3) = Target.Address Sheets("Spy").Cells(Sheets("Spy").Cells(65500, 4).End(xlUp).Row + 1, 4) = Target.Value End Sub "mlayden" skrev: I am trying to track changes that I am making to a workbook. This workbook has 4 different worksheets. This workbook also has links in it so everytime I go from one worksheet to the next it updates these links and then shows as if I made changes to it when I didn't. When i go to tools and track changes I've tried to choose the "where" but it only allows me to chose one worksheet to select my criteria. When i try to put multiple sheets in the "where" it says that my reference is invalid. Anyone have ideas? Also, is there anyway to track changes like they track in microsoft word? This would be even better and looks much nicer for what I am doing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel form for tracking task time | Excel Discussion (Misc queries) | |||
Excel template available for Defect Tracking | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) |