How do I create a comment on an unlocked cell in a protected sheet

G

Guest

Am not able to create a comment on an unlocked cell in a protected sheet.
Creating comments is not one of the features I can enable when protecting the
sheet. Please advise if you've faced/solved this problem before.
 
D

Dave Peterson

Unprotect your worksheet
tools|protection|protect sheet

You'll see an object to allow the user to edit Objects (phrasing/location
changes with versions of excel). Make sure you allow this.

and continue with the protection.

Remember that when you allow comments, you're also allowing the users to change
other objects, too--shapes/buttons/pictures....
 

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

Inserting Comments into Protected sheet 1
Can I protect data in a cell, but allow comments to be entered. 6
VBA code and protected cells 9
Changing Font in an unlocked cell in a protected sheet. 2
Help! Cannot select option buttons when Excel sheet is protected. 1
Cell Protection Query 15
Bypass unlocked cell on protected worksheet in Excel 2003? 8
Entering photos or pdf into a protected sheet 1

Top