Adding comments to unprotected cell in a protected sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to add comments to an unprotected cell in a protected
worksheet? The option to insert a comment is not available in the insert
menu even when the cursor is on the unprotected cell.

Thanks
Dave
 
If you allow objects to be edited, you can add them.

But maybe that's too much to allow?
 
Thank you that works.

What else will this allow the user to edit on the protected sheet? I am not
sure what is included under "Objects".

Thanks
Dave
 
shapes, pictures, controls, ...
Thank you that works.

What else will this allow the user to edit on the protected sheet? I am not
sure what is included under "Objects".

Thanks
Dave
Click to expand...
 

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

Similar Threads

Comments on Protected Sheet - Excel 2003 2
Can I protect data in a cell, but allow comments to be entered. 6
Show Comments on Protected Sheet 4
Inserting a comment box in a protected worksheet 2
Protect and Unprotect all worksheets with macro 2
Protection on Worksheets 5
Deleting Rows form Protected Sheet 1
Qualifying permissions in protect unprotect macro. 3

Back
Top