Inserting a Comment in a Protected Sheet?

G

Guest

I created a new timecard for our company and it looks great, is user friendly
except for one thing. Because I protected it to keep formulas from getting
edited you are now unable to "Insert Comments" by right clicking on a cell
and selecting Insert Comment. Is there any way to protect formulas in
specific cells while allowing in other cells Comments to be added? This is
how we write in specifics on what work was being done for the time entered in
a cell.

Thanks!
 
G

Guest

Users can add comments to protected cells if yoy check 'Allow users to edit
objects' when you protect the sheet. Doing this leaves your formula protected.

Mike
 

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

Top