Only allow to insert comment in Excel File


G

Guest

Dear All,

I would like to protect Excel worksheet for all users. So that all users
can't change the Excel content, but can insert comments.

How can I do this? Thanks
 
Ad

Advertisements

D

Dave Peterson

You can lock all the cells and the tools|Protection|protect sheet.

Depending on the version of excel, you'll see an option to Edit Objects
(xl2002+). Check that. xl2k and below have a check mark that you can toggle.

This will allow the users to edit all objects including comments--as well as
pictures/shapes/buttons/...
 

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


Top