How do I protect my comments from being edited by another user?
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 |
All times are GMT +1. The time now is 07:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com