View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
dodgo dodgo is offline
external usenet poster
 
Posts: 6
Default Inserting comments on protected worksheet

You also need to allow users to edit objects when you protect the
worksheet

Chris Hankin wrote:
Hello,

Could someone please advise on how I can insert comments into various
unprotected cells (Column AZ) whilst the worksheet is protected?

When I protected my worksheet, I chose the following:

Tools / Protection / Protect Worksheet and selected (ticked) the Select
unlocked cells check-box only.

The comments I wish to add will only be inserted in those cells in
Column AZ only.

Any help would be greatly appreciated.

Kind regards,

Chris.


Live Long and Prosper :-)

*** Sent via Developersdex http://www.developersdex.com ***