ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   enable commentaries when is protected (https://www.excelbanter.com/excel-worksheet-functions/36182-enable-commentaries-when-protected.html)

Ribap

enable commentaries when is protected
 

Hello, i need to write commentaries in some cells and also i need to
protect some other cells, the problem is that once i protect some cells
the commentaries get disabled in every cell in the worksheet. What can i
do?

Thanks.


--
Ribap
------------------------------------------------------------------------
Ribap's Profile: http://www.excelforum.com/member.php...o&userid=25382
View this thread: http://www.excelforum.com/showthread...hreadid=388593


Dave Peterson

When you protect the sheet, allow the users to edit objects.

The users will be able to add/delete/change comments. And they'll be able to do
things to other objects, too: pictures, buttons, checkboxes, etc...

Ribap wrote:

Hello, i need to write commentaries in some cells and also i need to
protect some other cells, the problem is that once i protect some cells
the commentaries get disabled in every cell in the worksheet. What can i
do?

Thanks.

--
Ribap
------------------------------------------------------------------------
Ribap's Profile: http://www.excelforum.com/member.php...o&userid=25382
View this thread: http://www.excelforum.com/showthread...hreadid=388593


--

Dave Peterson


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com