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