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

Dealing with the error: unable to filter on excel hc home school 0
Insert Comments on a Protected Worksheet 1
Protected Worksheets and Comments 1
adding comments to protected sheet 1
Enabling Autofilter and Sorting in a Protected Sheet 2
unprotect (in Excel 2007) workbook created and protected in Excel 7
Can I protect data in a cell, but allow comments to be entered. 6
Protected Workbook, no comments? 1

Top