I regularly send excel worksheets to a co-worker via e-mail and then she
sends it out to others within the company (sales force). There are occasions
when she will need to revise it and send it back to me. How do I protect my
comments so that they cannot be edited, or can I? I received a worksheet
back today that the comments I had entered were changed. These comments are
my back-up and I do not want them changed.

Can anybody help?

highlight the whole sheet
format cells / protection / uncheck locked
highlight the cells you want protected
format cells / protection / check locked
tools / protection / protect sheet / make a password

You can unlock the cells you want the users to be able to change.
(Format|cells|Protection tab)

Then protect the worksheet -- but make sure you don't all the users to Edit
Objects.

In xl2002+, it's near the bottom of that Tools|protect|protect sheet dialog.

In earlier versions, it was a checkbox on that dialog (IIRC).

In any case, worksheet protection is easily broken. This is not a really secure
way.

Maybe you could keep a backup copy of your original comments???

Laura L wrote:

I regularly send excel worksheets to a co-worker via e-mail and then she
sends it out to others within the company (sales force). There are occasions
when she will need to revise it and send it back to me. How do I protect my
comments so that they cannot be edited, or can I? I received a worksheet
back today that the comments I had entered were changed. These comments are
my back-up and I do not want them changed.

Can anybody help?

--

Dave Peterson

Then protect the worksheet -- but make sure you don't all the users to Edit
Objects.

Change that ALL to ALLOW.

....allow the users...

Dave Peterson wrote:

You can unlock the cells you want the users to be able to change.
(Format|cells|Protection tab)

Then protect the worksheet -- but make sure you don't all the users to Edit
Objects.

In xl2002+, it's near the bottom of that Tools|protect|protect sheet dialog.

In earlier versions, it was a checkbox on that dialog (IIRC).

In any case, worksheet protection is easily broken. This is not a really secure
way.

Maybe you could keep a backup copy of your original comments???

Laura L wrote:

I regularly send excel worksheets to a co-worker via e-mail and then she
sends it out to others within the company (sales force). There are occasions
when she will need to revise it and send it back to me. How do I protect my
comments so that they cannot be edited, or can I? I received a worksheet
back today that the comments I had entered were changed. These comments are
my back-up and I do not want them changed.

Can anybody help?

--

Dave Peterson

--

Dave Peterson

Thank you so much for your help!

"dlw" wrote:

highlight the whole sheet
format cells / protection / uncheck locked
highlight the cells you want protected
format cells / protection / check locked
tools / protection / protect sheet / make a password

Thank you so much for your help!

"Dave Peterson" wrote:

Then protect the worksheet -- but make sure you don't all the users to Edit
Objects.

Change that ALL to ALLOW.

....allow the users...

Dave Peterson wrote:

You can unlock the cells you want the users to be able to change.
(Format|cells|Protection tab)

Then protect the worksheet -- but make sure you don't all the users to Edit
Objects.

In xl2002+, it's near the bottom of that Tools|protect|protect sheet dialog.

In earlier versions, it was a checkbox on that dialog (IIRC).

In any case, worksheet protection is easily broken. This is not a really secure
way.

Maybe you could keep a backup copy of your original comments???

Laura L wrote:

I regularly send excel worksheets to a co-worker via e-mail and then she
sends it out to others within the company (sales force). There are occasions
when she will need to revise it and send it back to me. How do I protect my
comments so that they cannot be edited, or can I? I received a worksheet
back today that the comments I had entered were changed. These comments are
my back-up and I do not want them changed.

Can anybody help?

--

Dave Peterson

--

Dave Peterson