Hi Pooja Yes, you are right about the disabling "Track Changes" query you raised in your earlier mail. I missed out that feature. However, you may like to check out the following sites to know more about writing a code (you can password protect the same to prevent the macro from NOT running). However, I should tell you that I have myself not yet used module mentioned here.
http://www.ozgrid.com/VBA/track-changes.htm Not sure if it will help -- Ashish “If you enter this world knowing you are loved and you leave this world knowing the same, then everything that happens in between can be dealt with.” - A Quote from National Geographic Channel On 7/16/09, Pooja Sharma <vatspoojav...@gmail.com> wrote: > > Hi Ashish, > > Thanks! for the reply. But in this case, anyone can stop the Track Changes. > This won't work as a hidden kind of thing for others. > The purpose behind this is, that whenever anyone make changes on the > worksheet(which is in shared mode) and save it, then the changes should be > highlighted in a diff. worksheet or workbook. > > 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 >> >> >> >> -- >> 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 -~----------~----~----~----~------~----~------~--~---
