Dear VijayKumar Thanks for taking good interest in the problem and sharing your valuable knowledge and time. As you said, track changes does not work on any formatting changes. But I am not able to accept that keeping a text in text box and changing that text as a formatting operation. Basically I am not trying to change the font, size or any other format option. What I am trying is just edit the text inside the text box - say for example making a spelling correction. I am wondering how editing the text is being considered as a formatting work by Microsoft.
Thanks for your information on using the text box as the active X control in the developer tab. It is fine for when creating a new text box. I am facing this issue when I get a file that contains lots of text in text boxes. (For some additional information, my work involves making correction in the excel file containing text in various cells and text boxes. To show the client what I have changed, I use track changes in word and that is perfectly working. When it comes to excel, track changes is ok with the cells but not with the text boxes. The file I get has lots of text boxes) Regards Chandru On Sat, Sep 11, 2010 at 1:03 PM, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote: > Hello, > When you do track changes your workbook, Excel track and highlights the > changes made by you or everyone (as set) in the workbook.Others cannot use > and make changes or corrections if the work book is not shared with them. By > activating track changes excel by default shares the workbook.But track > changes does not work on any formatting changes i.e any formatting changes > are there then track changes will not work on them. As keeping text > box(normal text box form Insert shapes) and making changes in it is a > formatting change and track changes does not work on formatting changes your > text box is geeting locked to prevent it from being shred with other people > and from making any changes. > > But , there is a solution to your problem. Don't Insert text box from Insert > shapes.You also have a text box in active X controls which can be found in > the Insert tab of the developer menu bar.If the developer menu bar is not > shown on the menu bar you can activate it by selecting the show Developer > bar in the Ribbon in the Popular Tab of the Excel Options Menu.For Using the > active X Controls you have to have knowledge about Active X controls and > their properties. > > > > Regards, > P.VijayKumar -- ---------------------------------------------------------------------------------- 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
