Hi Ashish, Thanks! for the reply. But in this case, anyone can stop the Track Changes. This won't woks as a hidden kind of thing for others.
Regards Pooja On Thu, Jul 9, 2009 at 2:38 PM, Ashish Pradhan <ashlyprad...@gmail.com>wrote: > > 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 >> >> >> > > > > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
