Inserting Comments into Cells of Protected Worksheet

G

Guest

I have a worksheet that is password protected but allows users to add values
in certain cells. I can input information in the cells but when I want to
add a comment in the same cells, it is greyed out. When I unprotect the
sheet, I can add comments. I do not want to unprotect the sheet to the
users. Any suggestions?
 
G

Gord Dibben

Excel 2002 and 2003 versions and probably 2007
version............Tools>Protection>Protect Sheet. Checkmark in "Edit Objects"


Gord Dibben MS Excel MVP
 

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

Excel Protection 2
How can I merge unprotected cells in a protected worksheet? 1
Add comment in protected worksheet 3
Inserting comment in unlocked cell of protected Excel worksheet? 1
Insert/ delete row in protected worksheet 7
How do I add comments to a protected sheet? 1
Protected Workbook, no comments? 1
Allowing sort of protected cells 1

Top