Dear Vijaykumar As said earlier, I get excel files (mostly from Japanese clients) and they have a tendency to use lots of text boxes to make a good looking table or some forms to collect data. The method used by them is "Insert > Text box > Horizontal text box". The text boxes are NOT created using the active X control through the developer tab. In fact I have seen them doing that often.
Now the problem is we cannot tell all the clients not to use text box and to merge the cells and center the text for heading. They simply draw a text box and enter the title, make the font big etc. It may be hard to believe for you that, it is very very hard to see an excel file without the usage of text box. Now keeping the attitude of text box usage by the clients aside, my academic interest is why such a wonderful application like excel lacks a simple user functionality of allowing the editing of text box when the track changes option is selected. I think the track changes option was originally developed for word only. Later they added this function in Excel 2007 though excel is not an application intended to text editing. Now a days people use excel for entering lots of text because of its versatility. The the need for checking the text in excel file and editing arises. I even checked in Excel 2010 for any improvements but still it is the same. I may be wrong or missing some settings. I am expecting some improvements in Excel 2013 or later (Just guessing the version). Once again thanks for your interest. Regards Chandru On Sat, Sep 11, 2010 at 9:23 PM, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote: > Hello, > I want to know how you created text box in excel.In that only real problem > lies. please tell me how you create the text box in excel. > > > > Regards > Vijaykumar > > > On Sat, Sep 11, 2010 at 7:56 PM, Chandru <chandr...@gmail.com> wrote: >> >> 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
