View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default As soon as I protect my sheet, I can no longer insert comments...

Hi,

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


If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Shelby" wrote:

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! :o)