Inserting Comments into Cells of Protected Worksheet



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?



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