The final conclusion is text box gets locked during track changes. Thanks for the info.
On Fri, Sep 10, 2010 at 9:50 AM, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote: > 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.) 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.). 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