Cell Comments - Can they be 'very' locked programmatically

[Alan]

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]

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)