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
