Excel 2002 "Protect Sheet", but Allow "Insert Comments"?

Check the "Edit Objects" button.

VP Safe wrote:
>
> When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
> formulas from being deleted. Prior to turning on protection I unlocked the
> cells that I wanted users to be able to edit. And I have checked the box to
> "Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked
> Cells; Format cells; ".
>
> What I *don't* see on the "Protect Sheet" menu is an option to "Allow all
> users of this worksheet to: INSERT COMMENTS into unlocked cells.
>
> Do you know of any way that I can allow users to do this, without turning
> off the protection in MS Excel 2002?

--

Dave Peterson

Thanks - your answer to this question worked also! Thank you so much!

"VP Safe" wrote:

> When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
> formulas from being deleted. Prior to turning on protection I unlocked the
> cells that I wanted users to be able to edit. And I have checked the box to
> "Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked
> Cells; Format cells; ".
>
> What I *don't* see on the "Protect Sheet" menu is an option to "Allow all
> users of this worksheet to: INSERT COMMENTS into unlocked cells.
>
> Do you know of any way that I can allow users to do this, without turning
> off the protection in MS Excel 2002?
>

Check the "Edit Objects" button.

VP Safe wrote:
>
> When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
> formulas from being deleted. Prior to turning on protection I unlocked the
> cells that I wanted users to be able to edit. And I have checked the box to
> "Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked
> Cells; Format cells; ".
>
> What I *don't* see on the "Protect Sheet" menu is an option to "Allow all
> users of this worksheet to: INSERT COMMENTS into unlocked cells.
>
> Do you know of any way that I can allow users to do this, without turning
> off the protection in MS Excel 2002?

--

Dave Peterson

Thanks - your answer to this question worked also! Thank you so much!

"VP Safe" wrote:

> When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
> formulas from being deleted. Prior to turning on protection I unlocked the
> cells that I wanted users to be able to edit. And I have checked the box to
> "Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked
> Cells; Format cells; ".
>
> What I *don't* see on the "Protect Sheet" menu is an option to "Allow all
> users of this worksheet to: INSERT COMMENTS into unlocked cells.
>
> Do you know of any way that I can allow users to do this, without turning
> off the protection in MS Excel 2002?
>

When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
formulas from being deleted. Prior to turning on protection I unlocked the
cells that I wanted users to be able to edit. And I have checked the box to
"Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked
Cells; Format cells; ".

What I *don't* see on the "Protect Sheet" menu is an option to "Allow all
users of this worksheet to: INSERT COMMENTS into unlocked cells.

Do you know of any way that I can allow users to do this, without turning
off the protection in MS Excel 2002?

Check the "Edit Objects" button.

VP Safe wrote:
>
> When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
> formulas from being deleted. Prior to turning on protection I unlocked the
> cells that I wanted users to be able to edit. And I have checked the box to
> "Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked
> Cells; Format cells; ".
>
> What I *don't* see on the "Protect Sheet" menu is an option to "Allow all
> users of this worksheet to: INSERT COMMENTS into unlocked cells.
>
> Do you know of any way that I can allow users to do this, without turning
> off the protection in MS Excel 2002?

--

Dave Peterson

Thanks - your answer to this question worked also! Thank you so much!

"VP Safe" wrote:

> When using MS Excel 2002: I have turned on "Protect Sheet" to protect some
> formulas from being deleted. Prior to turning on protection I unlocked the
> cells that I wanted users to be able to edit. And I have checked the box to
> "Allow all users of this worksheet to:" "Select Locked Cells; Select Unlocked
> Cells; Format cells; ".
>
> What I *don't* see on the "Protect Sheet" menu is an option to "Allow all
> users of this worksheet to: INSERT COMMENTS into unlocked cells.
>
> Do you know of any way that I can allow users to do this, without turning
> off the protection in MS Excel 2002?
>