Re: $$Excel-Macros$$ Track changes inside text box in Excel

[P.VIJAYKUMAR]

Dear Chandru,


Thanks for your Concern. Your problem has also helped me to improve my
little knowledge of excel.Generally, we can send our suggestions and
opinions about Microsoft products through Miocrosoft
http://www.microsoft.com website   and any required changes may be made by
them in the newer versions of excel. Companies make changes to their
products according to customer needs and requirements. Hence,any changes or
suggestions put forward by customers may be favourably looked into.



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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[Chandru]

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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[P.VIJAYKUMAR]

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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[Chandru]

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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[P.VIJAYKUMAR]

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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[Chandru]

The final conclusion is text box gets locked during track changes.
Thanks for the info.

On Fri, Sep 10, 2010 at 9:50 AM, P.VIJAYKUMAR  wrote:
> Hello,
>
> You can use change tracking to log details about workbook changes every time
> that you save a workbook. This change history (change history: In a shared
> workbook, information that is maintained about changes made in past editing
> sessions. The information includes the name of the person who made each
> change, when the change was made, and what data was changed.) can help you
> identify any changes that were made to the data in the workbook, and you can
> then accept or reject those changes. Change tracking is especially useful
> when several users edit a workbook. It is also useful when you submit a
> workbook to reviewers for comments, and then want to merge the input that
> you receive into one copy of that workbook, incorporating the changes and
> comments that you want to keep.
>
> How change tracking works
>
> Change tracking is available only in shared workbooks. In fact, when you
> turn on change tracking, the workbook automatically becomes a shared
> workbook. Although a shared workbook is typically stored in a location where
> other users can access it, you can also track changes in a local copy of a
> shared workbook.
>
> When changes are made in the shared workbook, you can view the change
> history directly on the worksheet or on a separate history worksheet
> (History worksheet: A separate worksheet that lists changes being tracked in
> a shared workbook, including the name of the person who made the change,
> when and where it was made, what data was deleted or replaced, and how
> conflicts were resolved.). Either way, you can instantly review the details
> of each change. For example, you can see who made the change, what type of
> change was made, when it was made, what cells were affected, and what data
> was added or deleted.
>
> When you use change tracking, you should consider the following:
>
> Change tracking differs from undo and backupYou might expect that change
> tracking creates a backup copy of the workbook before changes are made, or
> that you can undo any of those changes. Unfortunately, you cannot use the
> change history to back out of changes by undoing them or by restoring an
> earlier version of the workbook. However, the history worksheet includes a
> record of all deleted data so that you can copy that data back to the
> original cells in the shared workbook. Because change tracking is not
> designed to help you return to earlier versions of a workbook, you should
> continue to back up workbooks that have change tracking in effect.
> Some types of changes are not trackedChanges that you make to cell
> contents are tracked, but other changes, such as formatting changes, are not
> tracked. Some Microsoft Office Excel features are unavailable in shared
> workbooks, and therefore cannot be tracked.
>
> So when you track changes the workbook automatically becomes shared and text
> book is a formatting change and  formatting changes are not tracked, so when
> you do track changes text box becomes locked.Hopes this  clears your doubt.
> Thanks & Regards,
> 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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[P.VIJAYKUMAR]

Hello,

You can use change tracking to log details about workbook changes every time
that you save a workbook. This change history (change history: In a shared
workbook, information that is maintained about changes made in past editing
sessions. The information includes the name of the person who made each
change, when the change was made, and what data was
changed.)can
help you identify any changes that were made to the data in the
workbook, and you can then accept or reject those changes. Change tracking
is especially useful when several users edit a workbook. It is also useful
when you submit a workbook to reviewers for comments, and then want to merge
the input that you receive into one copy of that workbook, incorporating the
changes and comments that you want to keep.
How change tracking works

Change tracking is available only in shared workbooks. In fact, when you
turn on change tracking, the workbook automatically becomes a shared
workbook. Although a shared workbook is typically stored in a location where
other users can access it, you can also track changes in a local copy of a
shared workbook.

When changes are made in the shared workbook, you can view the change
history directly on the worksheet or on a separate history
worksheet(History worksheet: A separate worksheet that lists changes
being tracked in
a shared workbook, including the name of the person who made the change,
when and where it was made, what data was deleted or replaced, and how
conflicts were 
resolved.).
Either way, you can instantly review the details of each change. For
example, you can see who made the change, what type of change was made, when
it was made, what cells were affected, and what data was added or deleted.

When you use change tracking, you should consider the following:

   - *Change tracking differs from undo and backup*You might expect that
   change tracking creates a backup copy of the workbook before changes are
   made, or that you can undo any of those changes. Unfortunately, you cannot
   use the change history to back out of changes by undoing them or by
   restoring an earlier version of the workbook. However, the history worksheet
   includes a record of all deleted data so that you can copy that data back to
   the original cells in the shared workbook. Because change tracking is not
   designed to help you return to earlier versions of a workbook, you should
   continue to back up workbooks that have change tracking in effect.
   - *Some types of changes are not tracked*Changes that you make to
   cell contents are tracked, but other changes, such as formatting changes,
   are not tracked. Some Microsoft Office Excel features are unavailable in
   shared workbooks, and therefore cannot be tracked.



So when you track changes the workbook automatically becomes shared and text
book is a formatting change and  formatting changes are not tracked, so when
you do track changes text box becomes locked.Hopes this  clears your doubt.

Thanks & Regards,
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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[Chandru]

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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[P.VIJAYKUMAR]

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



-- 









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


Track changes trial.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[Chandru]

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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[P.VIJAYKUMAR]

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



-- 









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

Re: $$Excel-Macros$$ Track changes inside text box in Excel

[samad khan]

hi
actually i did the same procedure as you mentioned but i didnt face this kind 
of problem i dont know why it happens to you
 
Regards 
Samad

--- On Sat, 9/4/10, Chandru  wrote:


From: Chandru 
Subject: $$Excel-Macros$$ Track changes inside text box in Excel
To: excel-macros@googlegroups.com
Date: Saturday, September 4, 2010, 7:20 AM


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



  

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

$$Excel-Macros$$ Track changes inside text box in Excel

[Chandru]

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