As soon as I protect my sheet, I can no longer insert comments...

S

Shelby

As soon as I protect my sheet, I can no longer insert comments, even though
the cells are unlocked. I have allowed the user to format the cells when
protecting the sheet. Argh! It is essential that comments may be added with a
little red triangle in the cell to indicate that they are present. Any help
will be very gratefully received! :blush:)
 
S

ShaneDevenshire

Hi,

Easy trick - When you choose Tools, Protection, Protect Sheet also check the
Edit Objects choice.


If this helps, please click the Yes button.
 
S

Shelby

Of course! I had interpreted that as allowing object such as other embedded
excel files to be edited which I don't want to happen. Brilliant! :0D
 

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

Can I protect data in a cell, but allow comments to be entered. 6
Inserting Comments into Protected sheet 1
Allow comments in protected sheet using VB 4
Adding comments into a protected worksheet 6
Insert Comments on a Protected Worksheet 1
protecting sheet blocking comment creation 3
How to protect some cells, but able to insert rows elsewhere? 6
Protecting a sheet with a list on it 3

Top