ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Tracking Changes in a different workbook (https://www.excelbanter.com/excel-programming/449597-tracking-changes-different-workbook.html)

baleshst

Tracking Changes in a different workbook
 
Hi,
Request you to help me out with the following.

I have a workbook by the name 1Hiten.xls, the problem is that its a very heavy workbook and keeping a track of changes made on it is very difficult. I dont want to use the track options in the 1Hiten.xls, or use any vba on this workbook.

However, instead I would like to write a vba code in a separate workbook (example:1Hitentracker.xls) which would register any changes made in 1Hiten.xls

Please note i am using excel 2010


All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com