Allow comments to be added to protected worksheet? - Excel 2007

S

sue@solotel

I have created a worsksheet with selected areas locked and then protected it.
My users want to be able to add comments where necessary but are not able to.
I cant seem to find anything in the help menu - any ideas?
 
G

Gord Dibben

When protecting the sheet "allow users to:"

Select unlocked cells and Edit Objects.

Note: with edit objects checked, users can insert comments in locked cells
if they are allowed to select those.


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

Insert Comments on a Protected Worksheet 1
Protected Worksheets and Comments 1
adding comments to protected sheet 1
unprotect (in Excel 2007) workbook created and protected in Excel 7
Protected worksheet allow users 1
Protected Workbook, no comments? 1
protecting sheet 1
Inserting comment in unlocked cell of protected Excel worksheet? 1

Top