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