Dear Vijayakumar Thanks for the reply. My point is that when I enable the track changes option in the Excel 2007 (Review > Track changes > Highlight changes), the editing of text box is locked by excel. (I am not sure if I have conveyed the exact point). Here I am not talking about the worksheet protect or unprotect in the shared work book. But I also tried changing the option "Protect Shared Workbook" and yet excel is not allowing the editing of text box, when I enable the Track changes > Highlight changes.
Can you please try to edit the text in the text box after doing the following. Click Review > Track changes > Highlight changes. Then the "Highlight changes" form will open. Check "Track changes when editing". Further there will be "When", "Who" and "Where". You may keep the default options and click OK. Now try editing the text box. Thanks for your valuable time. Regards Chandru On Thu, Sep 9, 2010 at 12:41 PM, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote: > Hello, > In the protect and share work book in the review menu the allow sharing > option was selected .When I deselected the option I was able to make > changes in the text box. I am attecing the cheged sheet for your reference . > > Regards, > P.Vijaykumar > > > > On Thu, Sep 9, 2010 at 11:40 AM, Chandru <chandr...@gmail.com> wrote: >> >> Thanks for the reply. I have checked and the sheet is not protected. I >> can make changes in the cell and not in the text box. Excel is locking >> the text box when I enable the track changes as ON. >> (This is still not a macro related question, but I am posting that >> some one may throw light in this issue) >> >> On Mon, Sep 6, 2010 at 8:14 AM, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote: >> > HELLO, >> > Your sheet may be protected or reject any changes in your sheet may be >> > enabled. to make any changes remove the protection or accept the >> > changes >> > you make >> > by using the accept or reject changes in the review menu. >> > >> > On Sat, Sep 4, 2010 at 7:50 PM, Chandru <chandr...@gmail.com> wrote: >> >> >> >> Hello >> >> >> >> I am enabling the track changes option in Excel 2007 (Review > Track >> >> changes > Highlight changes). >> >> The option allows to track the changes made inside the cells but when >> >> I try to edit the text inside the text box, excel is not allowing to >> >> make the change. Similarly it is not allowing to edit the comments. >> >> Basically it is locking the text box and comments. Any thoughts on >> >> this strange behavior of excel. >> >> >> >> Regards >> >> Chandru -- ---------------------------------------------------------------------------------- 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
