View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Cell Comments - Can they be 'very' locked programmatically

You could unlock the cells that the users can change (format|cells|protection
tab).

Then protect your worksheet.
tools|protection|protect sheet
In xl2002, there's an option for "edit objects"--make sure it's not checked.

I think it's a checkbox in earlier versions (but I don't recall).

But depending on the version of excel you're using, there are some things that
can't be done--formatting, deleting rows/columns, inserting rows/columns.

(xl2002+ can have individual settings that allow these kinds of things)

Alan wrote:

Hi All,

Is it possible to lock cell comments so that they cannot be manually
edited or deleted?

If relevant, the cells in question *must* remain unprotected to allow
user input.

Thanks,

Alan.


--

Dave Peterson