Hello, You can use change tracking to log details about workbook changes every time that you save a workbook. This change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.)<http://office.microsoft.com/client/helppreview.aspx?AssetId=HP101973819990&lcid=1033&NS=EXCEL&Version=12&CTT=4&origin=EC001022991>can help you identify any changes that were made to the data in the workbook, and you can then accept or reject those changes. Change tracking is especially useful when several users edit a workbook. It is also useful when you submit a workbook to reviewers for comments, and then want to merge the input that you receive into one copy of that workbook, incorporating the changes and comments that you want to keep. How change tracking works
Change tracking is available only in shared workbooks. In fact, when you turn on change tracking, the workbook automatically becomes a shared workbook. Although a shared workbook is typically stored in a location where other users can access it, you can also track changes in a local copy of a shared workbook. When changes are made in the shared workbook, you can view the change history directly on the worksheet or on a separate history worksheet(History worksheet: A separate worksheet that lists changes being tracked in a shared workbook, including the name of the person who made the change, when and where it was made, what data was deleted or replaced, and how conflicts were resolved.)<http://office.microsoft.com/client/helppreview.aspx?AssetId=HP101973819990&lcid=1033&NS=EXCEL&Version=12&CTT=4&origin=EC001022991>. Either way, you can instantly review the details of each change. For example, you can see who made the change, what type of change was made, when it was made, what cells were affected, and what data was added or deleted. When you use change tracking, you should consider the following: - *Change tracking differs from undo and backup* You might expect that change tracking creates a backup copy of the workbook before changes are made, or that you can undo any of those changes. Unfortunately, you cannot use the change history to back out of changes by undoing them or by restoring an earlier version of the workbook. However, the history worksheet includes a record of all deleted data so that you can copy that data back to the original cells in the shared workbook. Because change tracking is not designed to help you return to earlier versions of a workbook, you should continue to back up workbooks that have change tracking in effect. - *Some types of changes are not tracked* Changes that you make to cell contents are tracked, but other changes, such as formatting changes, are not tracked. Some Microsoft Office Excel features are unavailable in shared workbooks, and therefore cannot be tracked. So when you track changes the workbook automatically becomes shared and text book is a formatting change and formatting changes are not tracked, so when you do track changes text box becomes locked.Hopes this clears your doubt. Thanks & Regards, P.VIJAY KUMAR -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
