Prev: Mapped vs Network drives
Next: If sign of sum is negative change to positive
From: LPhillips on 12 Jan 2010 13:43
Can you tell me how to add comments to an individual cell when the worksheet
is protected? The option does not appear on the toolbar nor when right
clicking.
From: Pierre on 12 Jan 2010 13:48
On Jan 12, 12:43 pm, LPhillips <LPhill...(a)discussions.microsoft.com>
wrote:
> Can you tell me how to add comments to an individual cell when the worksheet
> is protected? The option does not appear on the toolbar nor when right
> clicking.

This might help you.
from:
http://www.mrexcel.com/forum/showthread.php?t=63962

"In other versions, if you protect the sheet, but uncheck the objects
box, this will allow for comments to be inserted"

Let us know the results.


Pierre
From: Gord Dibben on 12 Jan 2010 19:38
Tools>Protection>Protect Sheet>Allow users to:

Make sure "Edit Objects" is checkmarked.


Gord Dibben MS Excel MVP

On Tue, 12 Jan 2010 10:43:01 -0800, LPhillips
<LPhillips(a)discussions.microsoft.com> wrote:

>Can you tell me how to add comments to an individual cell when the worksheet
>is protected? The option does not appear on the toolbar nor when right
>clicking.

 | 
Pages: 1
Prev: Mapped vs Network drives
Next: If sign of sum is negative change to positive