protect row of cells


C

coltheplumb

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
 
Ad

Advertisements

S

ShaneDevenshire

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
 
Ad

Advertisements

C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top