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 > -- 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
