Hello Pooja To track changes on a new work sheet kindly follow the steps given below.
1. Activate the Track Changes Feature. 2. Assume that the changes have been made and saved in the work book. After changes have been made to the workbook, you can automatically create a new worksheet that lists all the changes that have been tracked. 3. Open the workbook and select (Tools -- Track Changes -- Highlight Changes. 4. Change "When" tab to "All" 5. In the same "Highlight Changes" box, Select "List Changes on new sheet" and press OK. 6. Another worksheet called History will be automatically created in your workbook. This will be inserted AFTER the last worksheet in your workbook. 7. However, remember that if you want a history of all changes, specially after restarting the workbook, copy the History Sheet to another file. And pressing Save after you have created the History File will delete this sheet. You will have to repeat the process mentioned in Steps 3-5 above again. Important point is to make sure that you change the tab to "All" as mentioned in Step 4 above. (I keep forgetting that) Hope this helps. -- Ashish "Of what use is freedom if it does not include the freedom to make mistakes" -- Mahatma Gandhi On 7/9/09, Pooja Sharma <vatspoojav...@gmail.com> wrote: > > Hi All, > > I want to know, if there is any other option, i.e., other than Track > Changes. I want to know in my excel sheet, if someone does any changes in > any column/Row/Cell for e.g., Adding one row in between of existing rows, > changing the values of cells. > There is a restriction in Track Changes, if someone has stop the Track > Changes option, then it won't work. > Therefore, I need to protect my data and find out if any invaluable changes > are going on in a different workbook or in the different worksheet. > > -- > Best Regards > Pooja Sharma > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
