View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jcolley05 jcolley05 is offline
external usenet poster
 
Posts: 5
Default Inserting a Comment in a Protected Sheet?

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!