Prev: Excel 2007: Conditional Formatting and Ribbon Data
Next: Print to file
From: Suju Thomas Suju on 17 Mar 2010 13:59
Can we add a comment for cells in a protected worksheet. I wanted to allow
feature to only add comment and not allow user to do any other modifications
From: trip_to_tokyo on 17 Mar 2010 14:21
EXCEL 2007

Yes.

To achieve take the following actions:-

1. Home / Cells group / click on downwards facing arrow in Format / Protect
Sheet / Protect Sheet window should launch / in here the following 3 fields
should have a tick in them:-

Protect worksheet and contents of locked cells

Select locked cells

Select unlocked cells

2. Add a tick to the following field:-

Edit objects

OK

3. To test try and enter data into any cells of the Protected Sheet (you
should not be able to do this).

4. Shift F2 in any cell / comments pane opens / insert comment / click in
another cell / comment goes in successfully.

Save file.

If my comments have helped please hit Yes.

Thanks.


"Suju Thomas" wrote:

> Can we add a comment for cells in a protected worksheet. I wanted to allow
> feature to only add comment and not allow user to do any other modifications
From: Gord Dibben on 17 Mar 2010 14:25
Select all cells.

Format>Cells>Protection>Lock all cells.

Tools>Protection>Protect Worksheet.

Allow users to...........select locked and unlocked cells, edit objects.

Add a password if you want.


Gord Dibben MS Excel MVP

On Wed, 17 Mar 2010 10:59:01 -0700, Suju Thomas <Suju
Thomas(a)discussions.microsoft.com> wrote:

>Can we add a comment for cells in a protected worksheet. I wanted to allow
>feature to only add comment and not allow user to do any other modifications

From: trip_to_tokyo on 17 Mar 2010 14:26
Sorry, forgot to mention that you need to put a password in after you select
Edit objects OK / and then put the password in again and hit OK.



"trip_to_tokyo" wrote:

> EXCEL 2007
>
> Yes.
>
> To achieve take the following actions:-
>
> 1. Home / Cells group / click on downwards facing arrow in Format / Protect
> Sheet / Protect Sheet window should launch / in here the following 3 fields
> should have a tick in them:-
>
> Protect worksheet and contents of locked cells
>
> Select locked cells
>
> Select unlocked cells
>
> 2. Add a tick to the following field:-
>
> Edit objects
>
> OK
>
> 3. To test try and enter data into any cells of the Protected Sheet (you
> should not be able to do this).
>
> 4. Shift F2 in any cell / comments pane opens / insert comment / click in
> another cell / comment goes in successfully.
>
> Save file.
>
> If my comments have helped please hit Yes.
>
> Thanks.
>
>
> "Suju Thomas" wrote:
>
> > Can we add a comment for cells in a protected worksheet. I wanted to allow
> > feature to only add comment and not allow user to do any other modifications
 | 
Pages: 1
Prev: Excel 2007: Conditional Formatting and Ribbon Data
Next: Print to file