When protecting the sheet "allow users to:"
Select unlocked cells and Edit Objects.
Note: with edit objects checked, users can insert comments in locked cells
if they are allowed to select those.
Gord Dibben MS Excel MVP
On Wed, 4 Nov 2009 15:00:02 -0800, sue@solotel
<suesolo
...@discussions.microsoft.com> wrote:
>I have created a worsksheet with selected areas locked and then protected it.
>My users want to be able to add comments where necessary but are not able to.
>I cant seem to find anything in the help menu - any ideas?
|
