Can I add a "Comment" to an unlocked cell in a protect worksheet
 

One of our operatives would like to add comments to onlocked cells within a
protected spreadsheet is this possible?

Can I add a "Comment" to an unlocked cell in a protect worksheet
 

Yes if you have Excel 2002 or newer.

ToolsProtectionProtect WorksheetAllow users to:

Checkmark "edit objects"

That will allow users to enter Comments in any cell, not just unlocked
cells, so best to disallow "select locked cells" also.


Gord Dibben MS Excel MVP


On Fri, 16 Jan 2009 15:29:01 -0800, bjb
wrote:

One of our operatives would like to add comments to onlocked cells within a
protected spreadsheet is this possible?

Can I add a "Comment" to an unlocked cell in a protect worksheet
 

xl2k (and before) has 3 options on that protection dialog.

One of them does the same as as the "edit objects"--maybe it's even named the
same????



Gord Dibben wrote:

Yes if you have Excel 2002 or newer.

ToolsProtectionProtect WorksheetAllow users to:

Checkmark "edit objects"

That will allow users to enter Comments in any cell, not just unlocked
cells, so best to disallow "select locked cells" also.

Gord Dibben MS Excel MVP

On Fri, 16 Jan 2009 15:29:01 -0800, bjb
wrote:

One of our operatives would like to add comments to onlocked cells within a
protected spreadsheet is this possible?

--

Dave Peterson

Can I add a "Comment" to an unlocked cell in a protect worksheet
 

Ps. But xl2k and before doesn't have that option (in the user interface) to
prevent the user from selecting locked cells.

Gord Dibben wrote:

Yes if you have Excel 2002 or newer.

ToolsProtectionProtect WorksheetAllow users to:

Checkmark "edit objects"

That will allow users to enter Comments in any cell, not just unlocked
cells, so best to disallow "select locked cells" also.

Gord Dibben MS Excel MVP

On Fri, 16 Jan 2009 15:29:01 -0800, bjb
wrote:

One of our operatives would like to add comments to onlocked cells within a
protected spreadsheet is this possible?

--

Dave Peterson

Can I add a "Comment" to an unlocked cell in a protect worksheet
 

Thanks Dave.

Can't remember that far back.


Gord

On Fri, 16 Jan 2009 19:50:56 -0600, Dave Peterson
wrote:

xl2k (and before) has 3 options on that protection dialog.

One of them does the same as as the "edit objects"--maybe it's even named the
same????



Gord Dibben wrote:

Yes if you have Excel 2002 or newer.

ToolsProtectionProtect WorksheetAllow users to:

Checkmark "edit objects"

That will allow users to enter Comments in any cell, not just unlocked
cells, so best to disallow "select locked cells" also.

Gord Dibben MS Excel MVP

On Fri, 16 Jan 2009 15:29:01 -0800, bjb
wrote:

One of our operatives would like to add comments to onlocked cells within a
protected spreadsheet is this possible?