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? |
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? |
All times are GMT +1. The time now is 05:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com