i am trying to protect 1 row of cells and the be able to use insert comments
the problem is for the 1 row of cells to be protected you have to protect the
whole sheet this then stops the insert comments option showing when i right
click . am using the most up to date exel .any help please
coltheplumb

Hi,

1. If you want to enter comments in a protected sheet, unprotect the sheet
and then
choose Tools, Protection, Protect Sheet and turn on the checkbox beside Edit
Objects in the Allows... area.

2. You can protect a single row by unlocking all cells in the sheet and then
selecting the singe row and locking those cells. You lock or unlock cells by
selecting them and choosing Format, Cells, Protection tab, check or
unchecking the Locked box. Locking doesn't take effect until you protect the
worksheet.

If this helps, please click the Yes button
--
Thanks,
Shane Devenshire


"coltheplumb" wrote:

i am trying to protect 1 row of cells and the be able to use insert comments
the problem is for the 1 row of cells to be protected you have to protect the
whole sheet this then stops the insert comments option showing when i right
click . am using the most up to date exel .any help please
coltheplumb

Hi shane thanks for that but i was hoping to not have to keep unprotecting
the sheet everytime i want to insert a comment . i know on the older version
of exel you could uncheck a box as an option in the protect sheet drop down
before protecting the sheet . Ho hum back to the drawing board

"ShaneDevenshire" wrote:

Hi,

1. If you want to enter comments in a protected sheet, unprotect the sheet
and then
choose Tools, Protection, Protect Sheet and turn on the checkbox beside Edit
Objects in the Allows... area.

2. You can protect a single row by unlocking all cells in the sheet and then
selecting the singe row and locking those cells. You lock or unlock cells by
selecting them and choosing Format, Cells, Protection tab, check or
unchecking the Locked box. Locking doesn't take effect until you protect the
worksheet.

If this helps, please click the Yes button
--
Thanks,
Shane Devenshire


"coltheplumb" wrote:

i am trying to protect 1 row of cells and the be able to use insert comments
the problem is for the 1 row of cells to be protected you have to protect the
whole sheet this then stops the insert comments option showing when i right
click . am using the most up to date exel .any help please
coltheplumb